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
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