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