On Wed, Feb 19, 2014 at 12:40 AM, Andres Freund <and...@2ndquadrant.com> wrote: > Was there an index only scan or just a index scan? Any chance of a > corrupted index?
Just an index scan. I think it's unlikely to be a corrupt index, because the customer said that he dropped and restored the index, and it's difficult to imagine how VACUUM FREEZE could then have impacted a plan with only a sequential scan. > Do you still have the page from before you did the VACUUM? It seems likely that I could get it, given that the problem persisted over several days (apparently there was an earlier, manual attempt to repair the damage by hand). I'm reasonably confident that I could get back an affected database by performing a point-in-time recovery. That would also give me the benefit of an environment that I could break as needed. -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers