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

Re: Index problem...

From: Carol Walter <walterc(at)indiana(dot)edu>
To: "Tomeh, Husam" <HTomeh(at)facorelogic(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Index problem...
Date: 2008-05-22 17:37:56
Message-ID: 76ECE23E-2F14-44C4-80F9-259581AF48E3@indiana.edu (view raw or flat)
Thread:
Lists: pgsql-admin
When I ran the query you specified I got relname of "pg_toast_16429.   
When I ran the REINDEX TABLE pg_toast_16429 the system responds that  
relation "pg_toast_16429" does not exist.

Carol

On May 22, 2008, at 1:02 PM, Tomeh, Husam wrote:

>
> 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: hubert depesz lubaczewskiDate: 2008-05-22 17:57:56
Subject: Re: Index problem...
Previous:From: Tomeh, HusamDate: 2008-05-22 17:02:10
Subject: Re: Index problem...

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