Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 229A264FD2E for ; Wed, 3 Dec 2008 13:53:55 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 53071-03 for ; Wed, 3 Dec 2008 13:53:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from depesz.com (depesz.com [78.46.78.198]) by mail.postgresql.org (Postfix) with ESMTP id D649564FC3A for ; Wed, 3 Dec 2008 13:53:51 -0400 (AST) Received: from depesz by depesz.com with local (Exim 4.69) (envelope-from ) id 1L7vv1-0007N7-U9; Wed, 03 Dec 2008 18:53:48 +0100 Date: Wed, 3 Dec 2008 18:53:47 +0100 From: hubert depesz lubaczewski To: Matthew Wakeling Cc: pgsql-performance@postgresql.org Subject: Re: Postgres using more memory than it should Message-ID: <20081203175347.GA27737@depesz.com> Reply-To: depesz@depesz.com References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/26 X-Sequence-Number: 32062 On Wed, Dec 03, 2008 at 04:01:48PM +0000, Matthew Wakeling wrote: > The work_mem setting on this machine is 1000MB, running Postgres 8.3.0. Check bug report from 2008-11-28, by Grzegorz Jaskiewicz: query failed, not enough memory on 8.3.5 http://archives.postgresql.org/pgsql-bugs/2008-11/msg00180.php depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007