On 19 September 2012 18:47, Tom Lane <t...@sss.pgh.pa.us> wrote: > BTW, what should our advice be for recovering from corruption due to > this bug? As far as the btree and GIN problems go, we can tell people > that REINDEX will fix it. And in 9.1, you don't really need to worry > about the visibility map being bad. But what do you do in 9.2, if > you have a bad visibility map? Is there any fix short of VACUUM FULL?
SET vacuum_freeze_table_age = 0; VACUUM; I'm writing the full notes out now. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
