On 2014-02-19 00:55:03 -0800, Peter Geoghegan wrote: > 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.
I am wondering whether it's possibly either the vm or the all-visible flag on the page... Greetings, Andres Freund -- Andres Freund 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