Re: [PERFORM] Error while vacuuming

2011-11-07 Thread Samuel Gendler
On Mon, Nov 7, 2011 at 10:33 PM, Bhakti Ghatkar wrote: > Tom, > > Currently we are using version 9.0.1. > > Which version shall we update to? 9.05 or 9.1 ? > 9.0.5 should be compatible with your installed db and contain any bug fixes that have been released. Which isn't to say that you shouldn'

Re: [PERFORM] Error while vacuuming

2011-11-07 Thread Bhakti Ghatkar
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 wrote: > Bhakti Ghatkar writes: > > Hi , > > While performing full vacuum we encountered the error below: > > > > INFO: vacuuming "pg_catalog.pg_index"

Re: [PERFORM] Error while vacuuming

2011-11-04 Thread Tom Lane
Bhakti Ghatkar writes: > Hi , > While performing full vacuum we encountered the error below: > INFO: vacuuming "pg_catalog.pg_index" > vacuumdb: vacuuming of database "" failed: ERROR: duplicate key value > violates unique constraint "c" > DETAIL: Key (indexrelid)=(2678) already exist

Re: [PERFORM] Error while vacuuming

2011-11-04 Thread Guillaume Cottenceau
Hi, May be corrupt index, have you tried REINDEX? (btw I failed to see how it is related to performance) Bhakti Ghatkar writes: > Hi , > > While performing full vacuum we encountered the error below: > > > INFO:  vacuuming "pg_catalog.pg_index" > vacuumdb: vacuuming of database "" failed:

[PERFORM] Error while vacuuming

2011-11-04 Thread Bhakti Ghatkar
Hi , While performing full vacuum we encountered the error below: INFO: vacuuming "pg_catalog.pg_index" vacuumdb: vacuuming of database "" failed: ERROR: duplicate key value violates unique constraint "c" DETAIL: Key (indexrelid)=(2678) already exists. We are using Postgres 9.0.1 Ca