Skip site navigation (1) Skip section navigation (2)

Re: A bit OT- RE: [PERFORM] Re-ordering .CONF params ... questions for this list

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: <nickf(at)ontko(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Cc: <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: A bit OT- RE: [PERFORM] Re-ordering .CONF params ... questions for this list
Date: 2003-06-16 16:28:07
Message-ID: 200306160928.07521.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-performance
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

In response to

pgsql-performance by date

Next:From: Tomaz BorstnarDate: 2003-06-16 17:38:19
Subject: functional indexes instead of regular index on field(s)?
Previous:From: Tom LaneDate: 2003-06-16 14:17:43
Subject: Re: 7.3 vs 7.2 - different query plan, bad performance

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-06-16 16:36:31
Subject: Re: PostgreSQL and Windows
Previous:From: Yurgis BaykshtisDate: 2003-06-16 16:21:33
Subject: Re: PostgreSQL and Windows

pgsql-advocacy by date

Next:From: scott.marloweDate: 2003-06-16 18:38:30
Subject: Re: Which database part 2
Previous:From: Jean-Michel POUREDate: 2003-06-16 15:25:48
Subject: Re: PostgreSQL presentation at LSM

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group