On 11.11.2011 19:15, Heikki Linnakangas wrote:
On 11.11.2011 17:47, Tom Lane wrote:
(3) In disaster
recovery scenarios, the last thing we want is to be imposing extra
conditions on what an already-stressed DBA has to do to fix things;
especially extra conditions that are different from the way it's worked
for the last ten years.
True.
On second thought, if XID wraparound is close enough that the DBA has to
log in to do manual vacuums to avoid it, relfrozenxid of the
trouble-making tables are surely older than default
vacuum_freeze_table_age, so plain VACUUM is enough to scan the whole table.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
