Re: slow queries, possibly disk io

От: Manfred Koizar
Тема: Re: slow queries, possibly disk io
Дата: ,
Msg-id: b7ap91lbhpi0jeggafms5ereqcv8knlu23@email.aon.at
(см: обсуждение, исходный текст)
Ответ на: Re: slow queries, possibly disk io  (Josh Close)
Список: pgsql-performance

Скрыть дерево обсуждения

slow queries, possibly disk io  (Josh Close, )
 Re: slow queries, possibly disk io  (John Arbash Meinel, )
  Re: slow queries, possibly disk io  (Josh Close, )
   Re: slow queries, possibly disk io  (Simon Riggs, )
    TIP 9: the planner will ignore... & datatypes  ("Marc Mamin", )
     Re: TIP 9: the planner will ignore... & datatypes  (Alvaro Herrera, )
 Re: slow queries, possibly disk io  (Dawid Kuroczko, )
 Re: slow queries, possibly disk io  (Christopher Kings-Lynne, )
  Re: slow queries, possibly disk io  (Josh Close, )
 slow queries, possibly disk io  (Josh Close, )
  Re: slow queries, possibly disk io  (Tom Lane, )
   Re: slow queries, possibly disk io  (Josh Close, )
   Re: slow queries, possibly disk io  (Josh Close, )
   Re: slow queries, possibly disk io  (Rudi Starcevic, )
    Re: slow queries, possibly disk io  (Josh Close, )
     Re: slow queries, possibly disk io  (Tom Lane, )
     Re: slow queries, possibly disk io  (Josh Close, )
      Re: slow queries, possibly disk io  (Manfred Koizar, )

>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 по дате сообщения:

От: John A Meinel
Дата:
Сообщение: Re: postgresql-8.0.1 performance tuning
От: Cosimo Streppone
Дата:
Сообщение: Re: postgresql-8.0.1 performance tuning