Re: Broken index?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Broken index?
Дата
Msg-id 22742.999871857@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Broken index?  (Paul Green <traktion@webleicester.co.uk>)
Ответы Re: Broken index?  (Paul Green <traktion@webleicester.co.uk>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: 'create view' error
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Broken index?