pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Kirkwood <markir@paradise.net.nz>
To: Shridhar Daithankar <shridhar@frodo.hserus.net>
Cc: Doug Y <dylists@ptd.net>
Cc: psql-performance@postgresql.org
Subject: Re: Clarification on some settings
Date: Thu, 13 May 2004 19:31:29 +1200
Message-ID: <40A32451.4010801@paradise.net.nz> (raw)
In-Reply-To: <40A1E83E.2000402@frodo.hserus.net>
References: <6.0.1.1.2.20040511163104.01e9cbb0@mail.traderonline.com>
	<40A1E83E.2000402@frodo.hserus.net>

Note that effective_cache_size is merely a hint to that planner to say 
"I have this much os buffer cache to use" - it is not actually allocated.

It is shared_buffers that will hurt you if it is too high (10000 - 25000 
is the usual sweet spot).

best wishes

Mark


Shridhar Daithankar wrote:

>
>>
>> Increasing the effective cache and sort mem didn't seem to make much 
>> of a difference. I'm guessing the eff cache was probably raised a bit 
>> too much, and shared_buffers is way to high.
>
>
> I agree. For shared buffers start with 5000 and increase in batches on 
> 1000. Or set it to a high value and check with ipcs for maximum shared 
> memory usage. If share memory usage peaks at 100MB, you don't need 
> more than say 120MB of buffers.
>
>
>



view thread (6+ messages)  latest in thread

Message-ID: <40A32451.4010801@paradise.net.nz>
Permalink:  ../40A32451.4010801@paradise.net.nz/
Also on:    postgresql.org/message-id/40A32451.4010801@paradise.net.nz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: markir@paradise.net.nz, shridhar@frodo.hserus.net, dylists@ptd.net, psql-performance@postgresql.org
  Subject: Re: Clarification on some settings
  In-Reply-To: <40A32451.4010801@paradise.net.nz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox