X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EC65C3CCB03 for ; Fri, 17 Dec 2004 21:10:58 +0000 (GMT) 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 66435-05 for ; Fri, 17 Dec 2004 21:10:54 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 9C05B3CCA2B for ; Fri, 17 Dec 2004 21:10:55 +0000 (GMT) Received: (qmail 3004 invoked by uid 500); 17 Dec 2004 21:23:45 -0000 Date: Fri, 17 Dec 2004 15:23:45 -0600 From: Bruno Wolff III To: Tom Lane Cc: josh@agliodbs.com, Pailloncy Jean-Gerard , pgsql-performance@postgresql.org Subject: Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Message-ID: <20041217212345.GC2119@wolff.to> Mail-Followup-To: Tom Lane , josh@agliodbs.com, Pailloncy Jean-Gerard , pgsql-performance@postgresql.org References: <3D4B6E62-5055-11D9-96E2-000A95DE2550@ifrance.com> <07F4E72A-5059-11D9-96E2-000A95DE2550@ifrance.com> <200412171047.49250.josh@agliodbs.com> <22121.1103312817@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <22121.1103312817@sss.pgh.pa.us> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/226 X-Sequence-Number: 9601 On Fri, Dec 17, 2004 at 14:46:57 -0500, Tom Lane wrote: > > This looks like it must be a memory leak in the gist indexing code > (either gist itself or tsearch2). I don't see any post-release fixes in > the 7.4 branch that look like they fixed any such thing :-(, so it's > probably still there in 7.4.7, and likely 8.0 too. Shouldn't that be 7.4.6? I am expecting there to be an eventual 7.4.7 because of some post 7.4.6 fixes that have gone in, but I haven't seen any other indications that this has already happened.