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