Viktor Juhanson wrote: > Could you please explain what does this command exactly do ? Will it start VACUUM on all databases > immidiatly ? > PGOPTIONS='-o vacuum_freeze_table_age=0' vacuumdb Yes, it will. See the documentation of vacuumdb for what exactly it does. This is just an example of how you could run the VACUUM necessary after an upgrade to 9.1.12. There are many other ways to set vacuum_freeze_table_age, like in postgresql.conf. You could also connect with psql, use the SET command to set the parameter and run VACUUM manually. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
