pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: Effective Cache Size
Date: Wed, 17 Sep 2003 16:33:09 +0530
Message-ID: <3F688CC5.12621.4EBFDCC@localhost> (raw)
In-Reply-To: <8F4A22E017460A458DB7BBAB65CA6AE502AA15@webbased9>

On 17 Sep 2003 at 11:48, Nick Barr wrote:

> Hi,
> 
> I have been following a thread on this list "Inconsistent performance"
> and had a few questions especially the bits about effective_cache_size.
> I have read some of the docs, and some other threads on this setting,
> and it seems to used by the planner to either choose a sequential or
> index scan. So it will not necessarily increase performance I suppose
> but instead choose the most optimal plan. Is this correct?

That is correct.

> Danger maths ahead. Beware!!!!
> 
> <maths>
>   141816K  buff
> + 1781764K cached
> -----------------
>   1923580K total
> 
> effective_cache_size = 1923580 / 8 = 240447.5
> </maths>

That would be bit too aggressive. I would say set it around 200K to leave room 
for odd stuff.

Rest seems fine with your configuration. Of course a latest version of 
postgresql is always good though..

Bye
 Shridhar

--
Power is danger.		-- The Centurion, "Balance of Terror", stardate 1709.2




view thread (6+ messages)

Message-ID: <3F688CC5.12621.4EBFDCC@localhost>
Permalink:  ../3F688CC5.12621.4EBFDCC@localhost/
Also on:    postgresql.org/message-id/3F688CC5.12621.4EBFDCC@localhost

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: shridhar_daithankar@persistent.co.in
  Subject: Re: Effective Cache Size
  In-Reply-To: <3F688CC5.12621.4EBFDCC@localhost>
  References: <8F4A22E017460A458DB7BBAB65CA6AE502AA15@webbased9> <3F688CC5.12621.4EBFDCC@localhost>

* 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