The docs say vacuum, but the param is vacuum_freeze_table_age, so do I
need to vacuum freeze all the tables, or is vacuum enough?
Also, will set vacuum_freeze_table_age = 0; vacuum freeze; work, or do
I need to modify the postgresql.conf and reload?
-Andy
--
Sent via pgsql-general mailing
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Il 05/12/2013 17:16, Andy Colson ha scritto:
Setting vacuum_freeze_table_age to 0 forces VACUUM to always scan all
pages, effectively ignoring the visibility map. In this way a scan of
the whole table is done, ensuring all old XIDs are replaced by
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Il 05/12/2013 17:16, Andy Colson ha scritto:
The docs say vacuum, but the param is vacuum_freeze_table_age, so
do I need to vacuum freeze all the tables, or is vacuum enough?
Also, will set vacuum_freeze_table_age = 0; vacuum freeze; work,
On 12/5/2013 11:29 AM, Giuseppe Broccolo wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Il 05/12/2013 17:16, Andy Colson ha scritto:
The docs say vacuum, but the param is vacuum_freeze_table_age, so
do I need to vacuum freeze all the tables, or is vacuum enough?
Also, will set