X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 703CFD1B276; Tue, 8 Jun 2004 14:28:09 -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 82221-07; Tue, 8 Jun 2004 17:28:07 +0000 (GMT) Received: from ecintweb.eldocomp.com (ecintweb.eldocomp.com [205.159.99.8]) by svr1.postgresql.org (Postfix) with ESMTP id 0F93DD1B233; Tue, 8 Jun 2004 14:28:05 -0300 (ADT) Received: by ecintweb.eldocomp.com with XWall v3.29f ; Tue, 8 Jun 2004 10:28:04 -0700 From: Naomi Walker To: Jie Liang Cc: Adi Alurkar , "pgsql-admin@postgresql.org" , "pgsql-bugs@postgresql.org" Reply-To: "nwalker@eldocomp.com" Subject: Re: out of memory error Date: Tue, 8 Jun 2004 10:28:02 -0700 X-Assembled-By: XWall v3.29f Message-ID: <40C5F722.1010804@eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=EXCUSE_16, LINES_OF_YELLING X-Spam-Level: X-Archive-Number: 200406/111 X-Sequence-Number: 13771 Jie Liang wrote: Does 7.3* support this? Can you tell me a bit more about it, please?=20=20 Hash aggregate..? >I had a similar problem after upgrade to 7.4.2, >Try:=20 >SET enable_hashagg =3D false; >Before you execute that SELECT stmt=20 >If you don't want disable it in postgresql.conf > >Jie Liang > >=20=20 > --------------------------------=20 -- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to w= hom it is addressed, and may contain information that is privileged, confid= ential and exempt from disclosure under applicable law. If you are not the = intended addressee, nor authorized to receive for the intended addressee, y= ou are hereby notified that you may not use, copy, disclose or distribute t= o anyone the message or any information contained in the message. If you ha= ve received this message in error, please immediately advise the sender by = reply email, and delete the message. Thank you.