X-Original-To: pgsql-advocacy@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 15B09475A45; Tue, 11 Feb 2003 12:34:21 -0500 (EST) Received: from grunt25.ihug.com.au (grunt25.ihug.com.au [203.109.249.145]) by postgresql.org (Postfix) with ESMTP id 2481A475D64; Tue, 11 Feb 2003 12:34:16 -0500 (EST) Received: from p43-tnt2.mel.ihug.com.au (postgresql.org) [203.173.164.43] by grunt25.ihug.com.au with esmtp (Exim 3.35 #1 (Debian)) id 18ieIS-00043x-00; Wed, 12 Feb 2003 04:34:16 +1100 Message-ID: <3E493415.9090004@postgresql.org> Date: Wed, 12 Feb 2003 04:34:13 +1100 From: Justin Clift User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Josh Berkus , Merlin Moncure , PostgresSQL Hackers Mailing List , pgsql-advocacy@postgresql.org Subject: Re: Changing the default configuration (was Re: References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <26004.1044980414@sss.pgh.pa.us> <3E492E06.2030702@postgresql.org> <200302110918.48614.josh@agliodbs.com> <26582.1044984365@sss.pgh.pa.us> In-Reply-To: <26582.1044984365@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/20 X-Sequence-Number: 778 Tom Lane wrote: > 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. > > A lower-tech way to accomplish the same result is to document these > alternatives in postgresql.conf comments and encourage people to review > that file, as Steve Crawford just suggested. But first we need the raw > knowledge. Without too much hacking around, you could pretty easily adapt the pg_autotune code to do proper profiles of a system with different settings. i.e. increment one setting at a time, run pgbench on it with some decent amount of transactions and users, stuff the results into a different database. Aggregate data over time kind of thing. Let it run for a week, etc. If it's helpful, there's a 100% spare Althon 1.6Ghz box around with (choose your OS) + Adaptec 29160 + 512MB RAM + 2 x 9GB Seagate Cheetah 10k rpm drives hanging around. No stress to set that up and let it run any long terms tests you'd like plus send back results. Regards and best wishes, Justin Clift > regards, tom lane -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi