From: Mark Kirkwood <markir@paradise.net.nz>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org, Sebastian Hennebrueder <usenet@laliluna.de>
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Date: Sat, 05 May 2007 19:19:09 +1200
Message-ID: <463C2FED.8020400@paradise.net.nz> (raw)
In-Reply-To: <200705041011.42313.josh@agliodbs.com>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: markir@paradise.net.nz, josh@agliodbs.com, usenet@laliluna.de
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
In-Reply-To: <463C2FED.8020400@paradise.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox