Index problem...

Поиск
Список
Период
Сортировка
От Carol Walter
Тема Index problem...
Дата
Msg-id 473E95AE-4622-4B45-88A8-7CC4FB9076A3@indiana.edu
обсуждение исходный текст
Ответы Re: Index problem...  ("Tomeh, Husam" <HTomeh@facorelogic.com>)
Список pgsql-admin
Greetings...

I'm getting an error.  The error says...

places=# REINDEX INDEX maps_map_id_seq;
ERROR:  "maps_map_id_seq" is not an index
places=# SELECT * FROM maps;
ERROR:  missing chunk number 0 for toast value 131343627

I have tried reindexing the index, the table, and the database.  I
continue to get this error.  What can I do to recover from this.

Carol Walter

PS  Let me say that I know this is my fault.  This index is very
bloated.  Yesterday, I tried to vacuum.   I got errors because
max_fsm_pages what set at a number that was too small.


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

Предыдущее
От: "Amit jain"
Дата:
Сообщение: Error while executing pg_dump "invalid memory alloc request size 4294967293"
Следующее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: Index problem...