Re: PostgreSQL Configuration Tool for Dummies

Поиск
Список
Период
Сортировка
От Kevin Hunter
Тема Re: PostgreSQL Configuration Tool for Dummies
Дата
Msg-id A7F79018-065E-4DDE-A050-C54FA8B27745@earlham.edu
обсуждение исходный текст
Ответ на PostgreSQL Configuration Tool for Dummies  ("Campbell, Lance" <lance@uiuc.edu>)
Список 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 по дате отправления:

Предыдущее
От: "Mikko Partio"
Дата:
Сообщение: Slow indexscan
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Replication