pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar@frodo.hserus.net>
To: gnari <gnari@simnet.is>
Cc: pgsql-performance@postgresql.org
Subject: Re: Insert are going slower ...
Date: Wed, 14 Jul 2004 15:43:22 +0530
Message-ID: <40F50742.1000007@frodo.hserus.net> (raw)
In-Reply-To: <003901c4698a$2cfb5a50$0100000a@wp2000>
References: <200407131850.52095.herve@elma.fr>
	<200407131010.30790.josh@agliodbs.com>
	<200407140142.11720.footcow@noos.fr>
	<003901c4698a$2cfb5a50$0100000a@wp2000>

gnari wrote:
> is there a recommended procedure to estimate
> the best value for effective_cache_size on a
> dedicated DB server ?

Rule of thumb(On linux): on a typically loaded machine, observe cache memory of 
the machine and allocate good chunk of it as effective cache.

To define good chunck of it, you need to consider how many other things are 
running on that machine. If it is file server + web server + database server, 
you have to allocate the resources depending upon requirement.

But remember It does not guarantee that it will be a good value. It is just a 
starting point..:-) You have to tune it further if required.

HTH

  Shridhar



view thread (17+ messages)  latest in thread

Message-ID: <40F50742.1000007@frodo.hserus.net>
Permalink:  ../40F50742.1000007@frodo.hserus.net/
Also on:    postgresql.org/message-id/40F50742.1000007@frodo.hserus.net

 · 

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: shridhar@frodo.hserus.net, gnari@simnet.is
  Subject: Re: Insert are going slower ...
  In-Reply-To: <40F50742.1000007@frodo.hserus.net>

* 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