Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id E423A2E0056
	for <pgsql-hackers-postgresql.org@developer.postgresql.org>;
	Fri,  6 Jun 2008 18:23:36 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 10949-09
	for <pgsql-hackers-postgresql.org@developer.postgresql.org>;
	Fri,  6 Jun 2008 18:23:30 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from roadrunner.wars-nicht.de (roadrunner.wars-nicht.de
	[88.198.26.233])
	by developer.postgresql.org (Postfix) with ESMTP id 0E7452E0044
	for <pgsql-hackers@postgresql.org>;
	Fri,  6 Jun 2008 18:23:34 -0300 (ADT)
Received: from iridium.wars-nicht.de (Qe102.q.pppool.de [89.53.225.2])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(Client did not present a certificate)
	by roadrunner.wars-nicht.de (Postfix) with ESMTP id DC8659D41A1
	for <pgsql-hackers@postgresql.org>;
	Fri,  6 Jun 2008 23:23:27 +0200 (CEST)
Received: from iridium.wars-nicht.de (iridium.wars-nicht.de [127.0.0.1])
	by iridium.wars-nicht.de (Postfix) with ESMTP id DAC533DC879
	for <pgsql-hackers@postgresql.org>;
	Fri,  6 Jun 2008 23:23:54 +0200 (CEST)
Date: Fri, 6 Jun 2008 23:23:54 +0200
From: Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
To: pgsql-hackers@postgresql.org
Subject: Re: Overhauling GUCS
Message-ID: <20080606232354.69d70b64@iridium.wars-nicht.de>
In-Reply-To: <48484453.7030105@cheapcomplexdevices.com>
References: <48409D1E.3070208@agliodbs.com>
	<200806010032.53337.peter_e@gmx.net>
	<Pine.GSO.4.64.0806020452220.26912@westnet.com>
	<17932.1212415926@sss.pgh.pa.us>
	<20080604131810.GH65238@decibel.org>
	<4846A483.8000001@pse-consulting.de>
	<Pine.GSO.4.64.0806041045520.2258@westnet.com>
	<29525.1212613052@sss.pgh.pa.us> <48472E47.7030701@dunslane.net>
	<7473.1212625397@sss.pgh.pa.us>
	<448BD875-FE20-4985-92CD-DFF6FC0641D3@blighty.com>
	<48484453.7030105@cheapcomplexdevices.com>
X-Mailer: Claws Mail 2.10.0 (GTK+ 2.12.0; i486-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200806/325
X-Sequence-Number: 119438

On Thu, 05 Jun 2008 12:53:55 -0700 Ron Mayer wrote:

> Steve Atkins wrote:
> > ... cross-platform (Windows, Linux, Solaris, OS X as a bare
> > minimum) 
> 
> I wonder how cross-platform the tuning algorithm itself is.
> 
> I could also imagine that decisions like "do I let the OS page
> cache, or postgres's buffer cache get most of the memory" are
> extremely OS dependent.

But you can hide most of the internal stuff from the user, either by
generating the config file for the platform the tool is running on or
by an option like "generate config for platform xyz".

If you have cross-platform already in place, this should not be much
overhead.


Kind regards

-- 
				Andreas 'ads' Scherbaum
German PostgreSQL User Group