From: James Mansion <james@mansionfamily.plus.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: Marinos Yannikos <mjy@geizhals.at>
Cc: pgsql-performance@postgresql.org
Subject: Re: Background writer underemphasized ...
Date: Sat, 19 Apr 2008 16:06:05 +0100
Message-ID: <480A0A5D.8060604@mansionfamily.plus.com> (raw)
In-Reply-To: <Pine.GSO.4.64.0804190507000.5519@westnet.com>
References: <480619CA.2080904@geizhals.at>
<Pine.GSO.4.64.0804161524410.27404@westnet.com>
<48079AED.8090906@geizhals.at>
<Pine.GSO.4.64.0804190507000.5519@westnet.com>
Greg Smith wrote:
> Using the background writer more assures that the cache on the
> controller is going to be written to aggressively, so it may be
> somewhat filled already come checkpoint time. If you leave the writer
> off, when the checkpoint comes you're much more likely to have the
> full 2GB available to absorb a large block of writes.
But isn't it the case that while using background writer might result in
*slightly* more data to write (since data that is updated several times
might actually be sent several times), the total amount of data in both
cases is much the same? And if the buffer backed up in the BGW case,
wouldn't it also back up (more?) if the writes are deferred? And in
fact by sending earlier, the real bottleneck (the disks) could have been
getting on with it and staring their IO earlier?
Can you explian your reasoning a bit more?
James
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: james@mansionfamily.plus.com, gsmith@gregsmith.com, mjy@geizhals.at
Subject: Re: Background writer underemphasized ...
In-Reply-To: <480A0A5D.8060604@mansionfamily.plus.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