Hi, May be corrupt index, have you tried REINDEX? (btw I failed to see how it is related to performance) Bhakti Ghatkar <bghatkar 'at' 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? > > Regards, > Bhakti > -- Guillaume Cottenceau -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
