X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5FCD0D9E6E for ; Mon, 3 Oct 2005 11:00:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20555-01 for ; Mon, 3 Oct 2005 14:00:15 +0000 (GMT) Received: from pc7.berlin.powerweb.de (pc7.berlin.powerweb.de [62.67.228.13]) by svr1.postgresql.org (Postfix) with ESMTP id ABCDFD9E61 for ; Mon, 3 Oct 2005 11:00:16 -0300 (ADT) Received: from [192.168.2.102] (p54ADB70A.dip0.t-ipconnect.de [84.173.183.10]) by pc7.berlin.powerweb.de (8.9.3p3/8.9.3) with ESMTP id QAA27012 for ; Mon, 3 Oct 2005 16:00:19 +0200 Message-ID: <4341399E.3040205@sector-x.de> Date: Mon, 03 Oct 2005 16:01:02 +0200 From: Harald Lau Organization: Sector-X GmbH User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: URGENT: pg_statistic_relid_att_index has gone References: <20051003110226.GA26883@uio.no> <434123CA.2020708@sector-x.de> In-Reply-To: <434123CA.2020708@sector-x.de> X-Enigmail-Version: 0.92.0.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200510/14 X-Sequence-Number: 14782 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > on a 7.2 System (Suse-Linux) I got an error "duplicate key in unique > index pg_statistic_relid_att_index" (think it was while vacuuming) > > I REINDEXd the database. > Now the table pg_statistic_relid_att_index is completely gone. go searching the internet first, man ... Surprisingly I'm not the first one having such a breakdown Found a solution provided by Tom Lane: http://www.xy1.org/pgsql-general@postgresql.org/msg04568.html Seems to work, many thanks Sorry for the overhasty question Harald -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (MingW32) Comment: GnuPT 2.7.2 iQEVAwUBQ0E5nXfX3+fgcdKcAQJWsgf+JvgWRjgl/RLBzGd8wNt7x6/VngGOzdpT 4E3OgbrGuAPEC3INkMLTLRU2hVvjRqgkNaWS2YlXpFmlAff6czGeSbwXv4vDiiH7 AYHpONACLgr8jcHohS0kmylqu/3QYSsmRBDOTOCNms1iMEmJZvpru9YJpSEjwWUL /n5pu5lurcpU+VGLTCikin5UnsNWmQzsegz+f2co3UuTDHIUER+W2538Fb9iiZBD P9TCI972U+oC2YTg+Puh22jPfS1gG7EHUxKt/XbE9klca1AnCdJX6LdsIh7vdMhw 6u8JzaaAz9nHtqYFpClkEpnkp9KEohw/uQyDUCB7FK//MRtSWx+MPw== =52pe -----END PGP SIGNATURE-----