From: Richard Huxton <dev@archonet.com>
To: Jack Coates <jack@lyris.com>
To: josh@agliodbs.com
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: tuning questions
Date: Thu, 4 Dec 2003 23:47:54 +0000
Message-ID: <200312042347.54461.dev@archonet.com> (raw)
In-Reply-To: <1070579771.18838.187.camel@cletus.lyris.com>
References: <1070553983.6498.52.camel@cletus.lyris.com>
<200312041324.37889.josh@agliodbs.com>
<1070579771.18838.187.camel@cletus.lyris.com>
On Thursday 04 December 2003 23:16, Jack Coates wrote:
>
> > > effective_cache_size = 10000
> >
> > This is way the heck too low. it's supposed to be the size of all
> > available RAM; I'd set it to 2GB*65% as a start.
>
> This makes a little bit of difference. I set it to 65% (15869 pages).
That's still only about 127MB (15869 * 8KB).
> Now we have some real disk IO:
> procs memory swap io
> system cpu
> r b w swpd free buff cache si so bi bo in cs us
> sy id
> 0 3 1 2804 10740 40808 1899856 0 0 26624 0 941 4144
According to this your cache is currently 1,899,856 KB which in 8KB blocks is
237,482 - be frugal and say effective_cache_size = 200000 (or even 150000 if
the trace above isn't typical).
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, jack@lyris.com, josh@agliodbs.com
Subject: Re: tuning questions
In-Reply-To: <200312042347.54461.dev@archonet.com>
* 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