Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9F49F9FA2FE for ; Wed, 12 Sep 2007 05:12:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 40973-05 for ; Wed, 12 Sep 2007 05:12:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id 5486E9F9A83 for ; Wed, 12 Sep 2007 05:12:07 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 06A6CB1F82 for ; Wed, 12 Sep 2007 10:12:06 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 1R5gD6ZtN0wq for ; Wed, 12 Sep 2007 10:12:05 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id E9A15B1F28; Wed, 12 Sep 2007 10:12:05 +0200 (CEST) Date: Wed, 12 Sep 2007 10:12:05 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: out of memory Message-ID: <20070912081205.GA29139@easy2.in-chemnitz.de> References: <10890.1189569501@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/73 X-Sequence-Number: 26834 On Tue, Sep 11, 2007 at 09:15:56PM -0700, Tena Sakai wrote: > But there's a problem, for which I hope you have > more wisdom. The reason why I tried that query > is because someone tried the same thing via odbc > from pc quering postgres database and got the > same error ("out of memory"). > > What can a pc user do? Anything? Tell the user that he/she should use an appropiate WHERE clause. You might also consider adding more swap to the machine. Then it will go horribly slow, but it will work. HTH, Tino. -- www.spiritualdesign-chemnitz.de www.lebensraum11.de Tino Schwarze * Parkstraße 17h * 09120 Chemnitz