Re: [GENERAL] 7.4b1 vs 7.3.4 performance

2003-08-28 Thread P. Joshua Rovero
Tom Lane wrote: "P.J. \"Josh\" Rovero" <[EMAIL PROTECTED]> writes: Ran sets of 150 pgbench runs, with clients (1, 2, 4, 8, 16) and transactions (5 each at 125, 250, 500, 1000, 2000, 4000), BTW, what was the pgbench "scale factor"? regards, tom lane 1 for these cases.

Re: [GENERAL] 7.4b1 vs 7.3.4 performance

2003-08-28 Thread Tom Lane
"P. Joshua Rovero" <[EMAIL PROTECTED]> writes: >>> Ran sets of 150 pgbench runs, with clients (1, 2, 4, 8, 16) and >>> transactions (5 each at 125, 250, 500, 1000, 2000, 4000), >> >> BTW, what was the pgbench "scale factor"? > 1 for these cases. Hm. You really want scale factor >= number of cli

Re: [GENERAL] 7.4b1 vs 7.3.4 performance

2003-08-21 Thread expect
On Thu, 21 Aug 2003 06:53:42 -0400 rovero <[EMAIL PROTECTED]> wrote: > expect wrote: > > > > > I don't know a lot about TPC but I understand it's meant to mimic > > multiple teller xactions and that's what you did. This is not a > > request mind you but it would be interesting to see how changi

Re: [GENERAL] 7.4b1 vs 7.3.4 performance

2003-08-21 Thread expect
On Thu, 21 Aug 2003 12:55:35 +0530 Shridhar Daithankar <[EMAIL PROTECTED]> wrote: > On Wednesday 20 August 2003 22:43, rovero wrote: > > expect wrote: > > > Where does pgbench come from? > > > > pgbench is one of the modules in the postgresql > > contrib directory. After building postgresql, > >

Re: [GENERAL] 7.4b1 vs 7.3.4 performance

2003-08-20 Thread Tom Lane
"P.J. \"Josh\" Rovero" <[EMAIL PROTECTED]> writes: > 7.4b1 is significantly faster (i.e., the higher curve) > over this range of clients and transactions. Cool. I wonder though why the 7.4 curve is so much noisier. regards, tom lane ---(end of bro