Postgres Pro
Downloads
Home   >   mailing lists

Re: Error while vacuuming - Mailing list pgsql-performance

From Bhakti Ghatkar
Subject Re: Error while vacuuming
Date
Msg-id CAJeA4QGAHzo=6Y6W_GDfEBW+C5zYObJXxXcuVw2f7mbda9jBHA@mail.gmail.com
Whole thread Raw
In response to Re: Error while vacuuming  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Error while vacuuming
List pgsql-performance
Tree view
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 by date:

Previous
From: Mohamed Hashim
Date:
Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!
Next
From: Samuel Gendler
Date:
Subject: Re: Error while vacuuming