Re: REINDEX needed because of index corruption need help ASAP

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: REINDEX needed because of index corruption need help ASAP
Дата
Msg-id 27755.1092435839@sss.pgh.pa.us
обсуждение исходный текст
Ответ на REINDEX needed because of index corruption need help ASAP  ("borajetta" <borajetta@hotmail.com>)
Список pgsql-performance
"borajetta" <borajetta@hotmail.com> writes:
> We are getting this error for other index's including primary key indexs wh=
> ere we get OID page not found errors and the index corruption as posted abo=
> ve.
> Sometimes when the index is broken it will cause run away searches which ea=
> t up all the memory and the server needs to be restarted.

It sounds to me like you have got hardware problems.  Get out your
memory and disk tests ...

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: "borajetta"
Дата:
Сообщение: REINDEX needed because of index corruption need help ASAP
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: REINDEX needed because of index corruption need help ASAP