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

Re: A smaller default postgresql.conf

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Joshua Drake <jd(at)commandprompt(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: A smaller default postgresql.conf
Date: 2008-08-19 21:28:31
Message-ID: Pine.GSO.4.64.0808191712520.7443@westnet.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, 19 Aug 2008, Josh Berkus wrote:

> Well, that doesn't help unless we either provide a .conf generation tool 
> (something I favor) or docs somewhere which explain which are the variables 
> to be the most concerned with instead of making users read through all 218 of 
> them.

The design for a pg_generate_conf tool you suggested that's now dumped 
into http://wiki.postgresql.org/wiki/GUCS_Overhaul#pg_generate_conf seemed 
the only reasonable solution I've ever heard here.  The difference of 
opinion between those those want a tiny file and those who want a full one 
cannot be reconciled.  It's not a logical debate, it's a religious one. 
The best you can do is provide something that's switchable to work for the 
most popular positions:

* "The file should be minimal"
* "Every parameter should be there with lots of documentation"
* "Just the important parameters should be listed"

Because no one who is firmly in one of those camps will ever move to 
another just by arguing here.

I'm going to rewrite that Wiki page to make it more obvious how the 
proposed changes actually map to resolving problems in this area.  Much of 
what's come up in this thread is already addressed there but that's 
clearly not obvious to most people.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2008-08-19 21:29:56
Subject: Re: A smaller default postgresql.conf
Previous:From: Dave PageDate: 2008-08-19 21:26:06
Subject: Re: A smaller default postgresql.conf

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