From: | Hitesh Bhambhani <hitesh(dot)bhambhani(at)asg(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #5599: Vacuum fails due to index corruption issues |
Date: | 2010-08-05 12:04:54 |
Message-ID: | 8B7319E089E48047A0B688CE9CF54FD855C3C916@USRES8MAIL.asg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Alvaro, thanks for your response.
My comments below...
> From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
> Sent: Wednesday, August 04, 2010 11:30 PM
> There probably is. What kind of relation are the ones unable to truncate?
> Please see in pg_class where relfilenode = '41274' in this
> case:
>
[HiteshB] the relation is called pmoinstance_idx_pmotypeid. This is an index on a table created by our product.
The definition for this index is:
CREATE INDEX pmoinstance_idx_pmotypeid ON pmoinstances USING btree (pmotype_id);
Regards,
Hitesh
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2010-08-05 12:24:42 | Re: BUG #5599: Vacuum fails due to index corruption issues |
Previous Message | Hitesh Bhambhani | 2010-08-05 11:55:44 | Re: BUG #5599: Vacuum fails due to index corruption issues |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2010-08-05 12:24:42 | Re: BUG #5599: Vacuum fails due to index corruption issues |
Previous Message | Hitesh Bhambhani | 2010-08-05 11:55:44 | Re: BUG #5599: Vacuum fails due to index corruption issues |