X-Original-To: pgsql-hackers@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 03ADA475C15 for ; Wed, 12 Feb 2003 01:21:21 -0500 (EST) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by postgresql.org (Postfix) with ESMTP id DC884475BF9 for ; Wed, 12 Feb 2003 01:21:18 -0500 (EST) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h1C6LK126354 for ; Wed, 12 Feb 2003 11:51:20 +0530 Received: from daithan.intranet.pspl.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h1C6LKw26349 for ; Wed, 12 Feb 2003 11:51:20 +0530 From: "Shridhar Daithankar" To: PostgresSQL Hackers Mailing List Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy] Date: Wed, 12 Feb 2003 11:51:44 +0530 User-Agent: KMail/1.5 References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <200302110918.48614.josh@agliodbs.com> <26582.1044984365@sss.pgh.pa.us> In-Reply-To: <26582.1044984365@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200302121151.44843.shridhar_daithankar@persistent.co.in> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/464 X-Sequence-Number: 35406 On Tuesday 11 Feb 2003 10:56 pm, you wrote: > Josh Berkus writes: > > What if we supplied several sample .conf files, and let the user choose > > which to copy into the database directory? We could have a "high read > > performance" profile, and a "transaction database" profile, and a > > "workstation" profile, and a "low impact" profile. > > Uh ... do we have a basis for recommending any particular sets of > parameters for these different scenarios? This could be a good idea > in the abstract, but I'm not sure I know enough to fill in the details. Let's take very simple scenario to supply pre-configured postgresql.conf. Assume that SHMMAX=Total memory/2 and supply different config files for 64MB/128Mb/256MB/512MB and above. Is it simple enough? Shridhar