X-Original-To: pgsql-hackers@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3BC1C475AAC for ; Tue, 11 Feb 2003 12:25:30 -0500 (EST) Received: from smtp020.tiscali.dk (smtp020.tiscali.dk [212.54.64.104]) by postgresql.org (Postfix) with ESMTP id 5ACD7475A97 for ; Tue, 11 Feb 2003 12:25:29 -0500 (EST) Received: from cpmail.dk.tiscali.com (mail.tiscali.dk [212.54.64.159]) by smtp020.tiscali.dk (8.12.5/8.12.5) with ESMTP id h1BHNnBT009927 for ; Tue, 11 Feb 2003 18:25:33 +0100 (MET) Received: from strider (213.237.10.83) by cpmail.dk.tiscali.com (6.0.053) id 3E282010002F58F2 for pgsql-hackers@postgresql.org; Tue, 11 Feb 2003 18:25:21 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Kaare Rasmussen Reply-To: kar@kakidata.dk To: PostgresSQL Hackers Mailing List Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy] Date: Tue, 11 Feb 2003 18:26:46 +0100 User-Agent: KMail/1.4.3 References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <3E492E06.2030702@postgresql.org> <200302110918.48614.josh@agliodbs.com> In-Reply-To: <200302110918.48614.josh@agliodbs.com> MIME-Version: 1.0 Message-Id: <200302111826.46674.kar@kakidata.dk> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/393 X-Sequence-Number: 35335 > 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 Exactly my first thought when reading the proposal for a setting suited for= =20 performance tests.=20 > performance" profile, and a "transaction database" profile, and a > "workstation" profile, and a "low impact" profile. We could even supply= a And a .benchmark profile :-) > Perl script that would adjust SHMMAX and SHMMALL on platforms where this > can be done from the command line. Or maybe configuration could be adjusted with ./configure if SHMMAX can be= =20 determined at that point? --=20 Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2501 Howitzvej 75 =C5ben 12.00-18.00 Email: kar@kakidata.dk 2000 Frederiksberg L=F8rdag 12.00-16.00 Web: www.suse.dk