Is there any way to check the status of the Index table.

Поиск
Список
Период
Сортировка
От AliE@atlas.com
Тема Is there any way to check the status of the Index table.
Дата
Msg-id E5B27B6CBA34D111B8FC0000C0105CF96ABCAB@ntserver3.atlas.com
обсуждение исходный текст
Ответы Re: [HACKERS] Is there any way to check the status of the Index table.  (ocie@paracel.com)
Список pgsql-hackers
We installed the 6.3.2 on our system and now the nature of our data
corruption has changed. It used to give us "BTP_CHAIN errors " message
but now it is doing a core dump. I have two questions.

1. Is there a way to check the status of the Index files to see if they
are OK and not corrupted? Since I did not know of anyway to test the
index files, We tried to start the system without reindexing and it
failed, yet after rendering, it works fine for almost a day. The
corruption happens almost after the pick hour everyday.
2. Do you know of a good way to read the Core Dump file? We have FreeBsd
Unix and I have tried to read the file with "gdb -c coredumpfile.core"
command, but it complains about the format of the file. Any clue?

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

Предыдущее
От: Brett McCormick
Дата:
Сообщение: Re: [HACKERS] Re: [PATCHES] Try again: S_LOCK reduced contentionh]
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: [QUESTIONS] money or dollar type