Re-ordering .CONF params ... questions for this list - Mailing list pgsql-performance

From Josh Berkus
Subject Re-ordering .CONF params ... questions for this list
Date
Msg-id 200306101101.46304.josh@agliodbs.com
Whole thread Raw
Responses Re: Re-ordering .CONF params ... questions for this list
Re: Re-ordering .CONF params ... questions for this list
List pgsql-performance
Folks,

We've been discussing this for a while on HACKERS.  However, I haven't been
getting much feedback on the specific order proposed.

Attached is an outline of my proposed re-ordering of postgresql.conf.sample.
Please send me comments.  I need to submit a patch by Thursday, so don't take
too long.

This is an effort to make the order of run-time params in
postgresql.conf.sample and in the docs more logical and less baffling to the
new DBA.

Questions:
1) Should "enable_implicit_from" go in the "Version/Platform Compatibility"
section where I have it now, or in "CLIENT CONNECTIONS-Statement Behavior",
or somewhere else?

2) Where should "preload_libraries" go?   I'm very reluctant to start a
"Misc." section.  Perhaps I should start a "LIBRARIES" section?

3) I have re-ordered each subsection somewhat.   The fixed ordering is based
on:
        a) My guess at the frequency with which that option will be changed,
with more common options toward the top of the subsection;
        b) Grouping for tightly related options and for options that cascade;
        c) where (a) and (b) are unclear, alpha order.
Does this order make sense looking at the file?

3) Should we use indenting in PostgreSQL.conf.sample?   I tend to think it
would make the file easier to read, but I'm not sure what effect it would
have, if any, on parsing the file and whether other people would find it easy
to read.



--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

Attachment

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
Next
From: Vincent van Leeuwen
Date:
Subject: Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning