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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
