| 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
| 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 |