X-Original-To: pgsql-advocacy@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5ECD6475B8A; Tue, 11 Feb 2003 12:19:47 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 47588475ADE; Tue, 11 Feb 2003 12:19:45 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2834295; Tue, 11 Feb 2003 09:19:56 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Justin Clift , Tom Lane Subject: Re: Changing the default configuration (was Re: Date: Tue, 11 Feb 2003 09:18:48 -0800 User-Agent: KMail/1.4.3 Cc: Merlin Moncure , PostgresSQL Hackers Mailing List , pgsql-advocacy@postgresql.org References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <26004.1044980414@sss.pgh.pa.us> <3E492E06.2030702@postgresql.org> In-Reply-To: <3E492E06.2030702@postgresql.org> MIME-Version: 1.0 Message-Id: <200302110918.48614.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/16 X-Sequence-Number: 774 Tom, Justin, > > What I would really like to do is set the default shared_buffers to > > 1000. That would be 8 meg worth of shared buffer space. Coupled with > > more-realistic settings for FSM size, we'd probably be talking a shared > > memory request approaching 16 meg. This is not enough RAM to bother > > any modern machine from a performance standpoint, but there are probably > > quite a few platforms out there that would need an increase in their > > stock SHMMAX kernel setting before they'd take it. What if we supplied several sample .conf files, and let the user choose whi= ch=20 to copy into the database directory? We could have a "high read=20 performance" profile, and a "transaction database" profile, and a=20 "workstation" profile, and a "low impact" profile. We could even supply a= =20 Perl script that would adjust SHMMAX and SHMMALL on platforms where this ca= n=20 be done from the command line. --=20 Josh Berkus Aglio Database Solutions San Francisco