Re: PostgreSQL Configuration Tool for Dummies - Mailing list pgsql-performance

From Kevin Hunter
Subject Re: PostgreSQL Configuration Tool for Dummies
Date
Msg-id A7F79018-065E-4DDE-A050-C54FA8B27745@earlham.edu
Whole thread Raw
In response to PostgreSQL Configuration Tool for Dummies  ("Campbell, Lance" <lance@uiuc.edu>)
List pgsql-performance
At 4:35p -0400 on 19 Jun 2007, Lance Campbell wrote:
> The parameters I would think we should calculate are:
> max_connections
> shared_buffers
> work_mem
> maintenance_work_mem
> effective_cache_size
> random_page_cost

 From an educational/newb standpoint, I notice that the page
currently spews out a configuration file completely in line with
what's currently there, comments and all.  May I suggest highlighting
what has been altered, perhaps above or below the textbox?  It would
make it immediately obvious, and easier to add an explanation of the
thought process involved.  Something like

What's changed from the default:

<li>
    <p><strong>max_connections = 5</strong></p>
    <p>This follows directly from you put above.  It is the maximum
number of concurrent connections Postgres will allow.</p>
</li>
<li>
    <p><strong>shared_buffers = 10000</strong></p>
    <p>This setting will take some time to get exactly right for your
needs.  Postgres uses this for ...</p>
</li>

Not something that necessarily needs to be spelled out in the .conf
file, but would, IMVHO, help minimally educate.

Kevin

pgsql-performance by date:

Previous
From: "Mikko Partio"
Date:
Subject: Slow indexscan
Next
From: Andrew Sullivan
Date:
Subject: Re: Replication