Received: from bastuba.partitur.se (bastuba.partitur.se [193.219.246.194]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA44025 for ; Mon, 24 Jan 2000 05:01:10 -0500 (EST) (envelope-from kudo@partitur.se) Received: from partitur.se (tb303.partitur.se [193.219.246.230]) by bastuba.partitur.se (8.8.8/8.8.8) with ESMTP id LAA24878; Mon, 24 Jan 2000 11:00:57 +0100 (CET) (envelope-from kudo@partitur.se) Sender: kudo@partitur.se Message-ID: <388C22D9.A66DB9C1@partitur.se> Date: Mon, 24 Jan 2000 11:00:57 +0100 From: Patrik Kudo Organization: Partitur Informationsteknik X-Mailer: Mozilla 4.7 [en] (X11; I; FreeBSD 3.3-RELEASE i386) X-Accept-Language: sv,en MIME-Version: 1.0 To: Tom Lane CC: "pgsql-sql@postgreSQL.org" , girgen@partitur.se Subject: Re: [SQL] Duplicate tuples with unique index References: <388876AD.A7FE47D3@partitur.se> <4877.948471782@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Thanks! We'll try it out. Regards, Patrik Kudo Tom Lane wrote: > Given the reference to pg_statistic, I wonder if you aren't getting > burnt by the recently-discovered bug wherein VACUUM ANALYZE tries to > create pg_statistic tuples that are too long. I recommend (a) patch > vacuum.c (see Dirk Lutzebaeck's nearby message); then (b) drop and > recreate html_text_idx; finally (c) DELETE FROM pg_statistic and > then VACUUM ANALYZE to rebuild it. Good luck! > > regards, tom lane