From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-patches@postgresql.org
Subject: Re: Automatic adjustment of bgwriter_lru_maxpages
Date: Tue, 15 May 2007 13:45:03 +0100
Message-ID: <4649AB4F.8050209@enterprisedb.com> (raw)
In-Reply-To: <Pine.GSO.4.64.0705140957360.9478@westnet.com>
References: <461E108D.6080709@enterprisedb.com>
<Pine.GSO.4.64.0705121926420.9615@westnet.com>
<20070514174531.71E0.ITAGAKI.TAKAHIRO@oss.ntt.co.jp>
<Pine.GSO.4.64.0705140926470.9478@westnet.com>
<9814.1179150750@sss.pgh.pa.us>
<Pine.GSO.4.64.0705140957360.9478@westnet.com>
Greg Smith wrote:
> I realized recently the task I should take on here is to run some more
> experiments with the latest code and pass along suggested techniques for
> producing/identifying the kind of problem conditions I've run into in
> the past; then we can see if other people can reproduce them. I got a
> new 8-core server I need to thrash anyway and will try and do just that
> starting tomorrow.
Yes, please do that. I can't imagine a situation where a tunable maximum
would help, but you've clearly spent a lot more time experimenting with
it than me.
I have noticed that on a heavily (over)loaded system with fully
saturated I/O, bgwriter doesn't make any difference because all the
backends need to wait for writes anyway. But it doesn't hurt either.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
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: heikki@enterprisedb.com, gsmith@gregsmith.com, pgsql-patches@postgresql.org
Subject: Re: Automatic adjustment of bgwriter_lru_maxpages
In-Reply-To: <4649AB4F.8050209@enterprisedb.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