X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E62D49FA3A3 for ; Fri, 5 May 2006 14:10:06 -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 75917-03 for ; Fri, 5 May 2006 14:10:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by postgresql.org (Postfix) with ESMTP id E1D019FA4DE for ; Fri, 5 May 2006 14:10:00 -0300 (ADT) Received: from osgiliath.mathom.us ([70.108.51.88]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0IYS007O9YCKSMN5@vms044.mailsrvcs.net> for pgsql-performance@postgresql.org; Fri, 05 May 2006 12:09:57 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id 83EA46EC9D for ; Fri, 05 May 2006 13:09:54 -0400 (EDT) Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath.home.mathom.us [127.0.0.1]) (amavisd-new, port 10024) with LMTP id GBMePo1n7hsz for ; Fri, 05 May 2006 13:09:54 -0400 (EDT) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id CB3E86ECDA; Fri, 05 May 2006 13:09:53 -0400 (EDT) Date: Fri, 05 May 2006 13:09:53 -0400 From: Michael Stone Subject: Re: Memory and/or cache issues? In-reply-to: <445B7E5D.5090601@i-logic.hu> To: pgsql-performance@postgresql.org Mail-followup-to: pgsql-performance@postgresql.org Message-id: <20060505170951.GK16533@mathom.us> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1; format=flowed Content-transfer-encoding: 8BIT Content-disposition: inline X-Virus-Scanned: Debian amavisd-new at mathom.us X-Pgp-Fingerprint: 53 FF 38 00 E7 DD 0A 9C 84 52 84 C5 EE DF 7C 88 References: <0C4841B42F87D51195BD00B0D020F5CB044B2614@MORPHEUS> <20060505145346.GJ16533@mathom.us> <445B7E5D.5090601@i-logic.hu> User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/120 X-Sequence-Number: 18907 On Fri, May 05, 2006 at 06:33:33PM +0200, Gábriel Ákos wrote: >if postgres tries to allocate more memory (because of settings enable >it) than the kernel itself is configured for, then you will see similar >error messages. If you're talking about the shared memory limits, postgres will bomb out fairly quickly in that case, IIRC. Mike Stone