Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id CC50D9FA557 for ; Mon, 15 Oct 2007 13:03:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 78636-03 for ; Mon, 15 Oct 2007 13:03:16 -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 DAC459FA518 for ; Mon, 15 Oct 2007 13:03:15 -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 l9FG3AiM017094; Mon, 15 Oct 2007 12:03:10 -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: <4712E15B.8000405@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> Comments: In-reply-to Darren Reed message dated "Sun, 14 Oct 2007 20:41:15 -0700" Date: Mon, 15 Oct 2007 12:03:10 -0400 Message-ID: <17093.1192464190@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/123 X-Sequence-Number: 27037 Darren Reed writes: > # /usr/pkg/bin/psql -U postgres template1 > psql: FATAL: out of memory > DETAIL: Failed on request of size 20. I'm starting to think there is something very broken about your machine :-(. Have you run any hardware diagnostics on it lately? The level of flakiness you're seeing starts to suggest bad RAM to me. 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. regards, tom lane