Re: BUG #3606: Query Plan Failure or Index Corruption?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #3606: Query Plan Failure or Index Corruption?
Дата
Msg-id 15323.1189195457@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #3606: Query Plan Failure or Index Corruption?  ("David Tulloss" <dtulloss@computersoftwareinc.com>)
Список 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 по дате отправления:

Предыдущее
От: "David Tulloss"
Дата:
Сообщение: BUG #3606: Query Plan Failure or Index Corruption?
Следующее
От: "Cade Cairns"
Дата:
Сообщение: BUG #3607: timestamp is behaving strangely