X-Original-To: pgsql-advocacy@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0A759474E5C; Thu, 13 Feb 2003 22:26:02 -0500 (EST) Received: from filer (12-234-86-219.client.attbi.com [12.234.86.219]) by postgresql.org (Postfix) with ESMTP id D04B8474E4F; Thu, 13 Feb 2003 22:26:00 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) (uid 1000) by filer with local; Thu, 13 Feb 2003 19:26:05 -0800 Date: Thu, 13 Feb 2003 19:26:05 -0800 From: Kevin Brown To: PostgresSQL Hackers Mailing List , pgsql-advocacy@postgresql.org Subject: Re: Changing the default configuration (was Re: Message-ID: <20030214032605.GA18932@filer> Mail-Followup-To: Kevin Brown , PostgresSQL Hackers Mailing List , pgsql-advocacy@postgresql.org References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <26582.1044984365@sss.pgh.pa.us> <3E493415.9090004@postgresql.org> <200302110948.39283.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: <200302110948.39283.josh@agliodbs.com> User-Agent: Mutt/1.4i Organization: Frobozzco International X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/71 X-Sequence-Number: 829 Josh Berkus 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. > > Sure. > Mostly-Read database, few users, good hardware, complex queries: > = High shared buffers and sort mem, high geqo and join collapse thresholds, > moderate fsm settings, defaults for WAL. > Same as above with many users and simple queries (webserver) = > same as above, except lower sort mem and higher connection limit > High-Transaction Database = > Moderate shared buffers and sort mem, high FSM settings, increase WAL files > and buffers. > Workstation = > Moderate to low shared buffers and sort mem, moderate FSM, defaults for WAL, > etc. > Low-Impact server = current defaults, more or less. Okay, but there should probably be one more, called "Benchmark". The real problem is what values to use for it. :-) -- Kevin Brown kevin@sysexperts.com