Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 28AFA9FB833 for ; Wed, 11 Apr 2007 11:19:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 32314-03 for ; Wed, 11 Apr 2007 11:19:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 883B69FB794 for ; Wed, 11 Apr 2007 11:19:33 -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 l3BEJT8k014048; Wed, 11 Apr 2007 10:19:30 -0400 (EDT) To: Peter Elmers cc: pgsql-admin@postgresql.org Subject: Re: Problems with precompiled pgsql on mac In-reply-to: <357C48D9-0DE3-4D3C-BE03-BA45425EB057@gmx.de> References: <4608071B.8030601@Sheeky.Biz> <6C97816F-36CE-4799-A03D-18A2A6B63984@gmx.de> <200703271029.24337.mlists@rp-online.de> <44CE9FCD-9009-4BCC-81A0-5A21CD7B3C21@gmx.de> <5DAA6F5A-BA8F-48FD-8741-EB5982CA7C99@gmx.de> <25695.1176215452@sss.pgh.pa.us> <357C48D9-0DE3-4D3C-BE03-BA45425EB057@gmx.de> Comments: In-reply-to Peter Elmers message dated "Wed, 11 Apr 2007 11:12:07 +0200" Date: Wed, 11 Apr 2007 10:19:29 -0400 Message-ID: <14047.1176301169@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/99 X-Sequence-Number: 25163 Peter Elmers writes: > Now i am ongoing to optimize the settings. Without changing the > sysctl.conf or rc, i am able to get postgres running with the > following settings: > max_connections = 40 > shared_buffers=640kB > Does anybody see any problems with theese settings? Yeah, that's only 80 buffers, which is at least one order of magnitude too low for reasonable performance, probably two orders. This would do for a toy installation that wasn't working hard, but not for any serious load. Darwin's default SHMMAX is barely enough for one postmaster; you really can't run two without fixing it. regards, tom lane