Skip site navigation (1) Skip section navigation (2)

Re: Index problem...

From: "Tomeh, Husam" <HTomeh(at)facorelogic(dot)com>
To: "Carol Walter" <walterc(at)indiana(dot)edu>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Index problem...
Date: 2008-05-22 17:02:10
Message-ID: F1B0F9305B343E43A1C3EECE48B853D501A847B9@CITGSNA01SXCH02.ana.firstamdata.com (view raw or flat)
Thread:
Lists: pgsql-admin
You may want to try to reindex the associated toast table and see if
that clears it up.

To get the name of the associated toast table, you may run this query:

   select relname from pg_class where oid = 
     (select reltoastrelid from pg_class where relname = 'maps');

Then, reindex it. 
    
   reindex table "toast table name" ..

-------

Regards,
    Husam

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Carol Walter
Sent: Thursday, May 22, 2008 9:42 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Index problem...

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.


-- 
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged.  If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited.  If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

                                   FADLD Tag
**********************************************************************

In response to

Responses

pgsql-admin by date

Next:From: Carol WalterDate: 2008-05-22 17:37:56
Subject: Re: Index problem...
Previous:From: Carol WalterDate: 2008-05-22 16:41:54
Subject: Index problem...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group