Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id DE95B133798E for ; Tue, 9 Nov 2010 11:22:40 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 54946-02 for ; Tue, 9 Nov 2010 15:22:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 1DEED1336B42 for ; Tue, 9 Nov 2010 11:22:32 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id oA9FMX9x017967; Tue, 9 Nov 2010 10:22:33 -0500 (EST) To: Till Kirchner cc: pgsql-performance@postgresql.org Subject: Re: out of memory problem In-reply-to: <4CD924F4.6000607@vti.bund.de> References: <4CD924F4.6000607@vti.bund.de> Comments: In-reply-to Till Kirchner message dated "Tue, 09 Nov 2010 11:39:48 +0100" Date: Tue, 09 Nov 2010 10:22:33 -0500 Message-ID: <17966.1289316153@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/116 X-Sequence-Number: 41140 Till Kirchner writes: > I get an out of memory problem I don't understand. It's pretty clear that something is leaking memory in the per-query context: > ExecutorState: 1833967692 total in 230 blocks; 9008 free (3 > chunks); 1833958684 used There doesn't seem to be anything in your query that is known to cause that sort of thing, so I'm guessing that the leak is being caused by the postgis functions you're using. You might ask about this on the postgis lists. regards, tom lane