Re: 7.4b1 vs 7.3.4 performance

On Tue, 19 Aug 2003 12:47:38 -0400
"P.J. \"Josh\" Rovero" <rovero@sonalysts.com> wrote:

> 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.

What were the config settings?

>
> 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@sonalysts.com    www.sonalysts.com    215 Parkway North
> Work: (860)326-3671 or 442-4355                     Waterford CT 06385
> ***********************************************************************
>