Re: slow queries, possibly disk io

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Josh Close <narshe(at)gmail(dot)com>
Cc: POSTGRES-PERFORMANCE <pgsql-performance(at)postgresql(dot)org>
Subject: Re: slow queries, possibly disk io
Date: 2005-05-31 18:18:13
Message-ID: b7ap91lbhpi0jeggafms5ereqcv8knlu23@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>On 5/31/05, Martin Fandel <martin(dot)fandel(at)alphyra-evs(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-05-31 18:46:33 Re: postgresql-8.0.1 performance tuning
Previous Message Marc G. Fournier 2005-05-31 17:45:56 Major flood of mail to lists ...