If I'm understanding the vacuum truncate bug correctly, it can be avoided if every 2^31 transactions[1] you:
SET vacuum_freeze_table_age = 0; VACUUM FREEZE; table_age = 0 disables partial vacuum and then everything[1] gets frozen, eliminating the risk. Or am I missing something? [1]: Obviously open transactions mean 2^31 isn't exact. -- Jim C. Nasby, Data Architect j...@nasby.net 512.569.9461 (cell) http://jim.nasby.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
