Re: Let's drop some GUCs (bgwriter)

Jim,

> But have you looked at how this affects response time, especially around
> checkpoints? Testing I've done shows that changing the variables in
> 8.0.3 can markedly reduce the impact of checkpoints. In many
> applications, maintaining low response times is more important than
> overall throughput, and that's where bgwriter tuning currently comes
> into play. Depending on hardware it may not be possible to simplify all
> these into a single number, either.

Hmmm ... can you give me the settings you used?   I'd like to check the 
response times.

--Josh

-- 
Josh Berkus
Aglio Database Solutions
San Francisco