Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EB8399FA133 for ; Mon, 15 Oct 2007 18:56:20 -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 86540-07 for ; Mon, 15 Oct 2007 18:56:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 2238C9F9D9B for ; Mon, 15 Oct 2007 18:56:17 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l9FLuBNo023810; Mon, 15 Oct 2007 17:56:12 -0400 (EDT) To: Darren Reed cc: Scott Marlowe , "Joshua D. Drake" , pgsql-admin@postgresql.org Subject: Re: Is my database now too big? In-reply-to: <4713CA8C.5020303@fastmail.net> References: <1191730382.18880.1214536197@webmail.messagingengine.com> <47087723.7040403@commandprompt.com> <1191744007.14918.1214548241@webmail.messagingengine.com> <4708A9DC.5060306@fastmail.net> <47097EA7.902@fastmail.net> <4712D97E.7010004@fastmail.net> <4712E15B.8000405@fastmail.net> <17093.1192464190@sss.pgh.pa.us> <4713CA8C.5020303@fastmail.net> Comments: In-reply-to Darren Reed message dated "Mon, 15 Oct 2007 13:16:12 -0700" Date: Mon, 15 Oct 2007 17:56:11 -0400 Message-ID: <23809.1192485371@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/131 X-Sequence-Number: 27045 Darren Reed writes: > Tom Lane wrote: >> Anyway, the above error should have also produced a map of per-context >> memory usage in the postmaster log (ie, postmaster stderr). If you >> could show us that, it might be revealing. > MessageContext: 267378688 total in 43 blocks; 1768 free (45 chunks); > 267376920 used > The standout problem is the "MessageContext" count. Indeed. And there shouldn't even be anything in MessageContext until the first client command has been received. Maybe you have something in ~/.psqlrc that you haven't told us about? regards, tom lane