X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D42F19FB285 for ; Mon, 10 Jul 2006 12:04:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 86999-04 for ; Mon, 10 Jul 2006 12:03:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 0DED79FB280 for ; Mon, 10 Jul 2006 12:03:56 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k6AF3roN021399; Mon, 10 Jul 2006 11:03:53 -0400 (EDT) To: Szabolcs BALLA cc: pgsql-admin@postgresql.org Subject: Re: Out of memory...why? In-reply-to: <44B2492C.5040207@confinsystems.com> References: <44B2492C.5040207@confinsystems.com> Comments: In-reply-to Szabolcs BALLA message dated "Mon, 10 Jul 2006 14:33:48 +0200" Date: Mon, 10 Jul 2006 11:03:53 -0400 Message-ID: <21398.1152543833@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/56 X-Sequence-Number: 22302 Szabolcs BALLA writes: > When I ran a backup script I got this message from the db (7.4.7) What's the script exactly? > SPI Exec: 645914648 total in 83 blocks; 8370416 free (19 chunks); > 637544232 used It looks like you've got a plpgsql function eating a lot of memory. Hard to tell from this info if the function code is to blame or if you've found a memory leak. regards, tom lane