Date: Sat, 05 May 2007 19:19:09 +1200
From: Mark Kirkwood <markir@paradise.net.nz>
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
In-reply-to: <200705041011.42313.josh@agliodbs.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org,
	Sebastian Hennebrueder <usenet@laliluna.de>
Message-id: <463C2FED.8020400@paradise.net.nz>
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7bit
References: 
 <OFC96167D5.6BB63AC2-ON652572C9.003B5263-652572C9.003E4142@lntinfotech.com>
	<Pine.LNX.4.64.0705011647360.12033@asgard.lang.hm>
	<463B61ED.20409@laliluna.de> <200705041011.42313.josh@agliodbs.com>
User-Agent: Thunderbird 1.5.0.10 (X11/20070313)

Josh Berkus wrote:
> Sebastian,
> 
>> Before inventing a hyper tool, we might consider to provide 3-5 example
>> szenarios for common hardware configurations. This consumes less time
>> and be discussed and defined in a couple of days. This is of course not
>> the correct option for a brandnew 20 spindle Sata 10.000 Raid 10 system
>> but these are probably not the target for default configurations.
> 
> That's been suggested a number of times, but some GUCs are really tied to the 
> *exact* amount of RAM you have available.  So I've never seen how "example 
> configurations" could help.
> 

I'm not convinced about this objection - having samples gives a bit of a 
heads up on *what* knobs you should at least look at changing.

Also it might be helpful on the -general or -perf lists to be able to 
say "try config 3 (or whatever we call 'em) and see what changes..."

I've certainly found the sample config files supplied with that database 
whose name begins with 'M' a useful *start* when I want something better 
than default...

Cheers

Mark