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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
