Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id BA17BB5DCA5
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri,  4 Nov 2011 10:22:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 30284-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri,  4 Nov 2011 13:22:06 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from kolab.mnc.ch (62-2-77-205.static.cablecom.ch [62.2.77.205])
	by mail.postgresql.org (Postfix) with ESMTP id C123AB5DCA8
	for <pgsql-performance@postgresql.org>;
	Fri,  4 Nov 2011 10:22:05 -0300 (ADT)
Received: from localhost (kolab.op.lan [127.0.0.1])
	by kolab.mnc.ch (Postfix) with ESMTP id 8159265AE6;
	Fri,  4 Nov 2011 14:21:58 +0100 (CET)
X-Virus-Scanned: by amavisd-new at mnc.ch
Received: from kolab.mnc.ch ([127.0.0.1])
	by localhost (kolab.mnc.ch [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id LyxdlalL3JfD; Fri,  4 Nov 2011 14:21:57 +0100 (CET)
Received: from localhost (kolab.op.lan [127.0.0.1])
	by kolab.mnc.ch (Postfix) with ESMTP id C6C5265AE8;
	Fri,  4 Nov 2011 14:21:57 +0100 (CET)
Received: from gc.localdomain (62-2-77-204.static.cablecom.ch [62.2.77.204])
	by kolab.mnc.ch (Postfix) with ESMTP id B53E765AE6;
	Fri,  4 Nov 2011 14:21:57 +0100 (CET)
Received: by gc.localdomain (Postfix, from userid 500)
	id EE55C18A305; Fri,  4 Nov 2011 14:21:53 +0100 (CET)
To: Bhakti Ghatkar <bghatkar@zedo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Error while vacuuming
References: 
 <CAJeA4QHVjPFvQP+Lg=mbTrFzsHRa9v+QwM1e_C-+6hSRG=-rAQ@mail.gmail.com>
From: Guillaume Cottenceau <gc@mnc.ch>
X-Hashcash: 
 1:21:111104:bghatkar@zedo.com::H10kFxkCfU+ccbX0:000000000000000000000000000000000000000000000xYj
X-Hashcash: 
 1:21:111104:pgsql-performance@postgresql.org::j9H6u9ZeGi7io1EE:00000000000000000000000000000Fpub
Date: Fri, 04 Nov 2011 14:21:53 +0100
In-Reply-To: 
 <CAJeA4QHVjPFvQP+Lg=mbTrFzsHRa9v+QwM1e_C-+6hSRG=-rAQ@mail.gmail.com>
	(Bhakti Ghatkar's message of "Fri\, 4 Nov 2011 17\:44\:21 +0530")
Message-ID: <m3k47gkopa.fsf@mnc.ch>
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.3 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201111/75
X-Sequence-Number: 45586

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