Re: index xyz is not a btree

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: index xyz is not a btree
Дата
Msg-id 24991.1118432952@sss.pgh.pa.us
обсуждение исходный текст
Ответ на index xyz is not a btree  ("David Parker" <dparker@tazznetworks.com>)
Список pgsql-general
"David Parker" <dparker@tazznetworks.com> writes:
> The error only happens intermittently, but every occurrence is
> consistent:
>
>     1) always the same index - "attribute_pkey" on our "attirbute" table
> - one created implicitly by a primary key constraint
>     2) the error happens during a vacuum command

Hmm ... that seems a bit too consistent for a hardware issue doesn't it?

Have you looked at the index file with pg_filedump, or even just od?

            regards, tom lane

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

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: Wrong select results after transaction (HELP PLS)
Следующее
От: Ian Harding
Дата:
Сообщение: PostgreSQL Certification