Simon,
> I guess I'd be concerned that the poor bgwriter can't do all of this
> work. I was thinking about a separate log writer, so we could have both
> bgwriter and logwriter active simultaneously on I/O. It has taken a
> while to get bgwriter to perform its duties efficiently, so I'd rather
> not give it so many that it performs them all badly.
Speaking of which, now that I have a target value for wal_buffers, I want
to re-test the bgwriter. In my previous tests, varying the bgwriter
settings on DBT2 had no discernable effect.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco