Re: Error while vacuuming

Поиск
Список
Период
Сортировка
От Bhakti Ghatkar
Тема Re: Error while vacuuming
Дата
Msg-id CAJeA4QGAHzo=6Y6W_GDfEBW+C5zYObJXxXcuVw2f7mbda9jBHA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Error while vacuuming  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Error while vacuuming  (Samuel Gendler <sgendler@ideasculptor.com>)
Список pgsql-performance
Дерево обсуждения
Tom,

Currently we are using version 9.0.1. 

Which version shall we update to? 9.05 or 9.1 ?

~Bhakti

On Fri, Nov 4, 2011 at 7:44 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Bhakti Ghatkar <bghatkar@zedo.com> writes:
> Hi ,
> While performing full vacuum we encountered the error below:


> INFO:  vacuuming "pg_catalog.pg_index"
> vacuumdb: vacuuming of database "xxxx" failed: ERROR:  duplicate key value
> violates unique constraint "ccccc"
> DETAIL:  Key (indexrelid)=(2678) already exists.

> We are using Postgres 9.0.1

> Can you please help us out in understanding the cause of this error?

Try updating ... that looks suspiciously like a bug that was fixed a few
months ago.

                       regards, tom lane

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

Предыдущее
От: Mohamed Hashim
Дата:
Сообщение: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!
Следующее
От: Samuel Gendler
Дата:
Сообщение: Re: Error while vacuuming