Re: slow queries, possibly disk io - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: slow queries, possibly disk io
Date
Msg-id b7ap91lbhpi0jeggafms5ereqcv8knlu23@email.aon.at
Whole thread Raw
In response to Re: slow queries, possibly disk io  (Josh Close <narshe@gmail.com>)
List pgsql-performance
>On 5/31/05, Martin Fandel <martin.fandel@alphyra-evs.de> 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 by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Major flood of mail to lists ...
Next
From: John A Meinel
Date:
Subject: Re: postgresql-8.0.1 performance tuning