Vacuuming and analyzing is the process that removes dead rows and also updates the statistics of a table.
As of PostgreSQL 8.3, auto vacuuming (the process that runs around cleaning up tables), is on by default. If you are
creating a lot of tables and bulk loading data, the vacuumer sometimes gets in your way. One way to get around that is to
disable auto vacuuming on the tables you are currently working on and then reenable afterward.
You can also do this from the PgAdmin III management console.
How do you disable and reenable auto vacuuming for a select table?
Navigate to the table in PgAdmin III explorer -> Select Table --> Properties and Click to go to Autovacuum tab
Note the other settings you can set in PgAdmin III. These can be set in SQL as well, and to see the SQL equivalent, simply set the
settings, and switch to the PGAdmin III SQL tab. It will show the ALTER TABLE statement to run to make the change.
Note that the described ALTER TABLE statements works since PostgreSQL 8.4 only. In earlier versions the DBA has to populate a system table called pg_autovacuum itself (or using PgAdmin III and the dialog you've described above). You might also find those settings not to be included in pg_dump before 8.4.