Index problem... - Mailing list pgsql-admin

From Carol Walter
Subject Index problem...
Date
Msg-id 473E95AE-4622-4B45-88A8-7CC4FB9076A3@indiana.edu
Whole thread Raw
Responses Re: Index problem...  ("Tomeh, Husam" <HTomeh@facorelogic.com>)
List 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 by date:

Previous
From: "Amit jain"
Date:
Subject: Error while executing pg_dump "invalid memory alloc request size 4294967293"
Next
From: "Tomeh, Husam"
Date:
Subject: Re: Index problem...