Re: Broken index?

Paul Green <traktion@webleicester.co.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