From: Josh Berkus <josh@agliodbs.com>
To: nickf@ontko.com
To: pgsql-performance@postgresql.org
Cc: pgsql-advocacy@postgresql.org
Subject: Re: A bit OT- RE: [PERFORM] Re-ordering .CONF params ... questions for this list
Date: Mon, 16 Jun 2003 09:28:07 -0700
Message-ID: <200306160928.07521.josh@agliodbs.com> (raw)
In-Reply-To: <NEBBLAAHGLEEPCGOBHDGCEIHHJAA.nickf@ontko.com>
References: <NEBBLAAHGLEEPCGOBHDGCEIHHJAA.nickf@ontko.com>
Nick,
> I agree... but are we the folks that the conf file needs to be made more
> intuitive for?
>
> If the intent is to make it easier for experienced folks like ourselves who
> are working with large or unusual databases to deal with PostgreSQL, then
> certainly the resource usage and tuning settings should go to the top.
> We'll set the other params once & never touch them again.
>
> On the other hand, I suspect that the majority of postgresql users play
> with the other params a bit during install to get their systems working and
> never touch the resource usage or tuning params ever. (And this is as it
> should be, given that the defaults are reasonable for most systems.)
This is a good argument. Though if you pursue it, surely you're advocating a
GUI tool for PostgreSQL.conf, not that that's a bad idea ...
How do other people feel about this? What options in PostgreSQL.conf do you
tweak most frequently?
--
Josh Berkus
Aglio Database Solutions
San Francisco
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, nickf@ontko.com, pgsql-advocacy@postgresql.org
Subject: Re: A bit OT- RE: [PERFORM] Re-ordering .CONF params ... questions for this list
In-Reply-To: <200306160928.07521.josh@agliodbs.com>
References: <NEBBLAAHGLEEPCGOBHDGCEIHHJAA.nickf@ontko.com> <200306160928.07521.josh@agliodbs.com>
* 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