Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 2E8CD9FB6F7 for ; Thu, 21 Jun 2007 03:11:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 08089-05 for ; Thu, 21 Jun 2007 03:10:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cronos.madness.at (madness.at [217.196.146.217]) by postgresql.org (Postfix) with ESMTP id F2F889FB6EF for ; Thu, 21 Jun 2007 03:10:56 -0300 (ADT) Received: from mastermind.kaltenbrunner.cc ([83.215.233.60]) by cronos.madness.at with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1I1FsZ-000353-74; Thu, 21 Jun 2007 08:10:55 +0200 Message-ID: <467A1669.4030004@kaltenbrunner.cc> Date: Thu, 21 Jun 2007 08:10:49 +0200 From: Stefan Kaltenbrunner User-Agent: Icedove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: "Campbell, Lance" CC: pgsql-performance@postgresql.org Subject: Re: PostgreSQL Configuration Tool for Dummies References: In-Reply-To: X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/459 X-Sequence-Number: 25492 Campbell, Lance wrote: > Now I am at the difficult part, what parameters to calculate and how to > calculate them. Everything below has to do with PostgreSQL version 8.2: > > > > The parameters I would think we should calculate are: > > max_connections > > shared_buffers > > work_mem > > maintenance_work_mem > > effective_cache_size > > random_page_cost > > > > Any other variables? I am open to suggestions. we also should scale max_fsm_pages according to the database size and workload answers - I also note that the configuration file it generates seems to look like on for PostgreSQL 7.x or something - I think we should just include the specific parameters to change. Stefan