X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0FC5F9DCA52 for ; Wed, 15 Feb 2006 12:45:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58875-08 for ; Wed, 15 Feb 2006 12:45:22 -0400 (AST) X-Greylist: whitelisted by SQLgrey- Received: from smtp6-g19.free.fr (smtp6-g19.free.fr [212.27.42.36]) by postgresql.org (Postfix) with ESMTP id DF4B19DCA09 for ; Wed, 15 Feb 2006 12:45:21 -0400 (AST) Received: from imp2-g19.free.fr (imp2-g19.free.fr [212.27.42.2]) by smtp6-g19.free.fr (Postfix) with ESMTP id 9D77F1820B; Wed, 15 Feb 2006 17:45:20 +0100 (CET) Received: by imp2-g19.free.fr (Postfix, from userid 33) id 683ED7AE33; Wed, 15 Feb 2006 17:45:20 +0100 (MET) Received: from wormhole.x-echo.com (wormhole.x-echo.com [193.252.148.11]) by imp2-g19.free.fr (IMP) with HTTP for ; Wed, 15 Feb 2006 17:45:20 +0100 Message-ID: <1140021920.43f35aa026fea@imp2-g19.free.fr> Date: Wed, 15 Feb 2006 17:45:20 +0100 From: martial.bizel@free.fr To: Scott Marlowe Cc: Tom Lane , pgsql-performance@postgresql.org Subject: Re: out of memory References: <1139930651.43f1f61b04773@imp2-g19.free.fr> <15115.1139931169@sss.pgh.pa.us> <1139933018.43f1ff5a5e542@imp6-g19.free.fr> <1139933201.22740.179.camel@state.g2switchworks.com> <1139933720.43f20218cfe3a@imp6-g19.free.fr> <19747.1139938612@sss.pgh.pa.us> <1139939253.22740.193.camel@state.g2switchworks.com> In-Reply-To: <1139939253.22740.193.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.5 X-Originating-IP: 193.252.148.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.655 required=5 tests=[AWL=0.105, NO_REAL_NAME=0.55] X-Spam-Score: 0.655 X-Spam-Level: X-Archive-Number: 200602/201 X-Sequence-Number: 17187 You're right, release is 7.4.7. there's twenty millions records "query" > On Tue, 2006-02-14 at 11:36, Tom Lane wrote: > > martial.bizel@free.fr writes: > > > Yes, I've launched ANALYZE command before sending request. > > > I precise that's postgres version is 7.3.4 > > > > Can't possibly be 7.3.4, that version didn't have HashAggregate. > > > > How many distinct values of "query" actually exist in the table? > > I thought that looked odd. > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >