I use software which makes a big PostgreSQL database (there is a table with a million rows in it) and the developers says I should
ANALYZE periodically. But the PostgreSQL database default is
autovacuum turned on.
Should I vacuum/analyze at all? What are the benefits? What's the difference between automatic and manual vacuum
For example, in Pgadmin3, I have this: