On Mon, Dec 06, 2004 at 07:52:37PM +0000, Simon Riggs wrote:
> Varying bgwriter_maxpages upwards should take performance higher.
>
I have 2 runs now. I for both tests, I have bgwriter_percent=100,
checkpoint_segments=8192, checkpoint_timout=600,
debug_shared_buffers=10, log_min_messages=debug1 and varied
bgwriter_maxpages.
http://www.osdl.org/projects/dbt2dev/results/dev4-010/206/
bgwriter_maxpages=100 (default)
throughput 3816.51
http://www.osdl.org/projects/dbt2dev/results/dev4-010/207/
bgwriter_maxpages=1000
throughput 3865.50
Another 1% change in overall throughput. I did catch in the oprofile
output that StrategyDirtyBufferList moved down the list a bit when I
increased bgwriter_maxpages.
Mark