On 2014-02-19 00:55:03 -0800, Peter Geoghegan wrote:
> On Wed, Feb 19, 2014 at 12:40 AM, Andres Freund <andres@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