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

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-hackers by date

Next:From: Greg StarkDate: 2010-08-05 12:24:42
Subject: Re: BUG #5599: Vacuum fails due to index corruption issues
Previous:From: Hitesh BhambhaniDate: 2010-08-05 11:55:44
Subject: Re: BUG #5599: Vacuum fails due to index corruption issues

pgsql-bugs by date

Next:From: Greg StarkDate: 2010-08-05 12:24:42
Subject: Re: BUG #5599: Vacuum fails due to index corruption issues
Previous:From: Hitesh BhambhaniDate: 2010-08-05 11:55:44
Subject: Re: BUG #5599: Vacuum fails due to index corruption issues

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