Re: Setting Shared Buffers , Effective Cache, Sort Mem Parameters

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Pallav Kalva <pkalva(at)deg(dot)cc>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Setting Shared Buffers , Effective Cache, Sort Mem Parameters
Date: 2004-04-22 22:50:37
Message-ID: ubig80lo5itco1o393hlu43ijsqppskgbr@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 22 Apr 2004 13:51:42 -0400, Pallav Kalva <pkalva(at)deg(dot)cc> wrote:
>I need some help with setting these parameters (shared buffers,
>effective cache, sort mem) in the pg_conf file.

It really depends on the kind of queries you intend to run, the number
of concurrent active connections, the size of the working set (active
part of the database), what else is running on the machine, and and and
...

Setting shared_buffers to 10000, effective_cache_size to 400000 (80% of
installed RAM), and sort_mem to a few thousand might be a good start.

> Also can anyone explain
>the difference between shared buffers and effective cache , how these
>are allocated in the main memory (the docs are not clear on this).

Shared_buffers directly controls how many pages are allocated as
internal cache. Effective_cache_size doesn't allocate anything, it is
just a hint to the planner how much cache is available on the system
level.

Servus
Manfred

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message CoL 2004-04-22 23:05:20 Re: Looking for ideas on how to speed up warehouse loading
Previous Message Sean Shanny 2004-04-22 21:56:59 Looking for ideas on how to speed up warehouse loading