Ran sets of 150 pgbench runs, with clients (1, 2, 4, 8, 16) and
transactions (5 each at 125, 250, 500, 1000, 2000, 4000),
then parsed and plotted with gnuplot. Breaks between number
of clients are at run index 31, 61, 91, etc. A vacuum
full was performed at each change of number of clients.
Graph attached.
Machine was a quad xeon, two separate database spaces
on a 3 disk software RAID-0 array. Config file parameters
(buffers, sort mem, logging, etc) were the same.
7.4b1 is significantly faster (i.e., the higher curve)
over this range of clients and transactions.
Will rerun with a vacuum between each number clients/transactions
combination.
--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero(at)sonalysts(dot)com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************
