Re: slow queries, possibly disk io

Поиск
Список
Период
Сортировка
Искать
От
Manfred Koizar
Тема
Re: slow queries, possibly disk io
Дата
в 15:49:39
Msg-id
b7ap91lbhpi0jeggafms5ereqcv8knlu23@email.aon.at
Ответ на
Список
Дерево обсуждения
slow queries, possibly disk io Josh Close <narshe@gmail.com>
Re: slow queries, possibly disk io John Arbash Meinel <john@arbash-meinel.com>
Re: slow queries, possibly disk io Josh Close <narshe@gmail.com>
Re: slow queries, possibly disk io Simon Riggs <simon@2ndquadrant.com>
Re: slow queries, possibly disk io Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: slow queries, possibly disk io Josh Close <narshe@gmail.com>
Re: slow queries, possibly disk io Dawid Kuroczko <qnex42@gmail.com>
>On 5/31/05, Martin Fandel  wrote:
>> In the documentation of
>> http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
>> is the shared_buffers set to 1/3 of the availble RAM.

Well, it says "you should never use more than 1/3 of your available RAM"
which is not quite the same as "it is set to 1/3."  I'd even say, never
set it higher than 1/10 of your available RAM, unless you know what
you're doing and why you're doing it.

Servus
 Manfred
В списке pgsql-performance по дате отправления
От: Marc G. Fournier
Дата:
От: John A Meinel
Дата:
FAQ