Re: Index problem...
От | Carol Walter |
---|---|
Тема | Re: Index problem... |
Дата | |
Msg-id | 76ECE23E-2F14-44C4-80F9-259581AF48E3@indiana.edu обсуждение исходный текст |
Ответ на | Re: Index problem... ("Tomeh, Husam" <HTomeh@facorelogic.com>) |
Ответы |
Re: Index problem...
(hubert depesz lubaczewski <depesz@depesz.com>)
|
Список | 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@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Carol Walter > Sent: Thursday, May 22, 2008 9:42 AM > To: pgsql-admin@postgresql.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@postgresql.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 > **********************************************************************
В списке pgsql-admin по дате отправления: