Index problem...

From: Carol Walter <walterc(at)indiana(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Index problem...
Date: 2008-05-22 16:41:54
Message-ID: 473E95AE-4622-4B45-88A8-7CC4FB9076A3@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tomeh, Husam 2008-05-22 17:02:10 Re: Index problem...
Previous Message Amit jain 2008-05-22 13:47:45 Error while executing pg_dump "invalid memory alloc request size 4294967293"