| From: | Josh Rovero <rovero(at)sonalysts(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | More on 7.4b2 vs 7.3.4 performance |
| Date: | 2003-09-01 15:25:21 |
| Message-ID: | 3F5364E1.4060203@sonalysts.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| Attachment | Content-Type | Size |
|---|---|---|
|
image/png | 8.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2003-09-01 15:50:41 | Re: Prevent from Deletion |
| Previous Message | Dennis Gearon | 2003-09-01 15:13:21 | Re: Prevent from Deletion |