Re: BUG #5599: Vacuum fails due to index corruption issues

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

In response to

Responses

Browse pgsql-bugs by date

  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

Browse pgsql-hackers by date

  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