Bhakti Ghatkar <bghatkar@xxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance