From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Josh Rovero <rovero(at)sonalysts(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: More on 7.4b2 vs 7.3.4 performance |
Date: | 2003-09-01 16:59:53 |
Message-ID: | 200309011659.h81Gxrw17416@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Josh Rovero wrote:
> Per Tom Lane's suggestion, I increased the pgbench
> scale factor to be equal to the max number of clients
> in each test run.
>
> Attached sample graph shows 1 - 10 clients,
> 100-500 transactions per client, with scale
> factor=10 for all runs.
>
> There is still a average 9% improvement in 7.4b2
> transaction rates over 7.3.4. For low number
> of clients (1 - 3) performance was almost the
> same. For higher numbers of clients, the 7.4
> advantage was often in the 15-25% range. Other
> tests with scale factor == number of clients and
> other pertubations gave similar results.
> 7.4 is almost always faster than 7.3.4.
>
> Mind you now, I am *not* complaining.
That's closer to the performance improvement we were expecting.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bo Lorentsen | 2003-09-01 17:10:41 | Re: mysql's last_insert_id |
Previous Message | Bruce Momjian | 2003-09-01 16:52:02 | Re: delivering database stand-alone |