> 9.2 + DW patch > ----------------------------------- > FPW off FPW on DW on/FPW off > CK on CK on CK on > one disk: 11078 10394 3296 [1G shared_buffers, 8G RAM] > sep log disk: 13605 12015 3412 > > one disk: 7731 6613 2670 [1G shared_buffers, 2G RAM] > sep log disk: 6752 6129 2722 >
On my single Hard disk test with write cache turned off I see different results than what Dan sees.. DBT2 50-warehouse, 1hr steady state with shared_buffers 1G, checkpoint_segments=128 as common settings on 8GB RAM) (checkpoints were on for all cases) with 8 Core . FPW off: 3942.25 NOTPM FPW on: 3613.37 NOTPM DW on : 3479.15 NOTPM I retried it with 2 core also and get similar results. So high evictions does have slighly higher penalty than FPW. My run somehow did not collect the background writer stats so dont have that comparison for these runs but have fixed it for the next runs. Regards, Jignesh -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
