Re: Broken index?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul Green <traktion(at)webleicester(dot)co(dot)uk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Broken index?
Date: 2001-09-07 14:10:57
Message-ID: 22742.999871857@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Paul Green <traktion(at)webleicester(dot)co(dot)uk> writes:
> I am having a problem with duplicates appearing in a unique index and I
> have no idea why.

Hmm. What PG version is this, on what platform?

Have you tried dropping and recreating the index?

> I can't say how often these duplicates slip through, but it seems to only
> happen *very* rarely, but is obviously completely mangling my data. Not
> only that, but VACUUM ANALYZE is taking *days* to complete and I can only
> assume this is due to these duplicates. The 'player' table contains around
> 180000 records, so if this fall of in performance when running vacuum can
> be associated with this, I'd appreciate some feedback.

Clearly something broken here; that's not an especially large table...

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Paul Green 2001-09-07 14:39:17 Re: Broken index?
Previous Message Peter Eisentraut 2001-09-07 13:38:17 Re: 'create view' error