Re: BUG #3606: Query Plan Failure or Index Corruption? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3606: Query Plan Failure or Index Corruption?
Date
Msg-id 15323.1189195457@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3606: Query Plan Failure or Index Corruption?  ("David Tulloss" <dtulloss@computersoftwareinc.com>)
List pgsql-bugs
"David Tulloss" <dtulloss@computersoftwareinc.com> writes:
> I am operating under the assumption that we have an index corruption because
> things work upon restore and then degrade under usage.

It sounds much more like you're not vacuuming often enough and/or don't
have max_fsm_pages set high enough.  However, without a lot more details
than you have provided here, we can only speculate.  If you think there
is an actual bug involved, please read the reporting guidelines at
http://www.postgresql.org/docs/8.2/static/bug-reporting.html

            regards, tom lane

pgsql-bugs by date:

Previous
From: "David Tulloss"
Date:
Subject: BUG #3606: Query Plan Failure or Index Corruption?
Next
From: "Cade Cairns"
Date:
Subject: BUG #3607: timestamp is behaving strangely