pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hervé Piedvache <herve@elma.fr>
To: pgsql-performance@postgresql.org
Cc: Shridhar Daithankar <shridhar@frodo.hserus.net>
Cc: gnari <gnari@simnet.is>
Subject: Re: Insert are going slower ...
Date: Wed, 14 Jul 2004 16:08:27 +0200
Message-ID: <200407141608.27116.herve@elma.fr> (raw)
In-Reply-To: <40F50742.1000007@frodo.hserus.net>
References: <200407131850.52095.herve@elma.fr>
	<003901c4698a$2cfb5a50$0100000a@wp2000>
	<40F50742.1000007@frodo.hserus.net>

Le mercredi 14 Juillet 2004 12:13, Shridhar Daithankar a écrit :
> 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.

In my case it's a PostgreSQL dedicated server ...

effective_cache_size = 5000000 

For me I give to the planner the information that the kernel is able to cache 
5000000 disk page in RAM

>free
             total       used       free     shared    buffers     cached
Mem:       7959120    7712164     246956          0      17372    7165704
-/+ buffers/cache:     529088    7430032
Swap:      2097136       9880    2087256

What should I put ?

Regards,
-- 
Hervé Piedvache

Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Pho. 33-144949901
Fax. 33-144949902



view thread (17+ messages)  latest in thread

Message-ID: <200407141608.27116.herve@elma.fr>
Permalink:  ../200407141608.27116.herve@elma.fr/
Also on:    postgresql.org/message-id/200407141608.27116.herve@elma.fr

 · 

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

* 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