Re: [GENERAL] vacuum_freeze_table_age for 9.3.2

2013-12-05 Thread Andy Colson
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 vacuu

Re: [GENERAL] vacuum_freeze_table_age for 9.3.2

2013-12-05 Thread Giuseppe Broccolo
-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;" wo

Re: [GENERAL] vacuum_freeze_table_age for 9.3.2

2013-12-05 Thread Giuseppe Broccolo
-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