Skip site navigation (1) Skip section navigation (2)

Re: Insert are going slower ...

From: Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net>
To: gnari <gnari(at)simnet(dot)is>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Insert are going slower ...
Date: 2004-07-14 10:13:22
Message-ID: 40F50742.1000007@frodo.hserus.net (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Hervé PiedvacheDate: 2004-07-14 14:08:27
Subject: Re: Insert are going slower ...
Previous:From: gnariDate: 2004-07-14 10:06:05
Subject: Re: Insert are going slower ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group