Differences between version 39 and previous revision of PgBench.
Other diffs: Previous Major Revision, Previous Author, or view the Annotated Edit History
| Newer page: | version 39 | Last edited on Tuesday, June 20, 2006 12:25:14 am | by GuyThornley | Revert |
| Older page: | version 38 | Last edited on Monday, June 19, 2006 10:54:38 pm | by GuyThornley | Revert |
@@ -41,29 +41,17 @@
* LinuxKernel 2.4.27 from [Debian]’s <tt>kernel-image-2.4.27-2-686-smp</tt> [Package]
* Using [Ext3] with 128MB journal and <tt>ordered</tt> data mode
On with the testing!
+
+__Update__: On Tue Jun 20 2006, all results were replaced with updated results. The previous test results were invalid and incomparable, due to inconsistencies and errors in the testing process.
!! Results: 4-disk configurations
* Data array: RAID5, 4x 72GB 10k RPM%%%
WAL array: On data array%%%
<pre>
- scaling factor: 100
- number of clients: 100
- number of transactions per client: 100
- number of transactions actually processed: 10000/10000
- tps = 132.257337 (including connections establishing)
- tps = 141.908320 (excluding connections establishing)
-
- scaling factor: 600
- number of clients: 100
- number of transactions per client: 1000
- number of transactions actually processed: 100000/100000
- tps = 114.351628 (including connections establishing)
- tps = 114.418688 (excluding connections establishing)
-
scaling factor: 600
number of clients: 100
number of transactions per client: 500
number of transactions actually processed: 50000/50000
@@ -75,29 +63,8 @@
WAL array: On data array%%%
Other notes: <tt>commit_delay</tt> disabled%%%
<pre>
- scaling factor: 100
- number of clients: 100
- number of transactions per client: 100
- number of transactions actually processed: 10000/10000
- tps = 135.567199 (including connections establishing)
- tps = 146.354640 (excluding connections establishing)
-
- scaling factor: 600
- number of clients: 100
- number of transactions per client: 1000
- number of transactions actually processed: 100000/100000
- tps = 118.365607 (including connections establishing)
- tps = 118.442501 (excluding connections establishing)
-
- scaling factor: 600
- number of clients: 100
- number of transactions per client: 500
- number of transactions actually processed: 50000/50000
- tps = 124.696768 (including connections establishing)
- tps = 124.870136 (excluding connections establishing)
-
scaling factor: 600
number of clients: 100
number of transactions per client: 500
number of transactions actually processed: 50000/50000
@@ -109,22 +76,8 @@
WAL array: On data array%%%
Other notes: battery-backed write cache disabled%%%
<pre>
- scaling factor: 100
- number of clients: 100
- number of transactions per client: 50
- number of transactions actually processed: 5000/5000
- tps = 76.678506 (including connections establishing)
- tps = 83.263195 (excluding connections establishing)
-
- scaling factor: 600
- number of clients: 100
- number of transactions per client: 500
- number of transactions actually processed: 50000/50000
- tps = 103.447886 (including connections establishing)
- tps = 103.556659 (excluding connections establishing)
-
scaling factor: 600
number of clients: 100
number of transactions per client: 500
number of transactions actually processed: 50000/50000
@@ -136,22 +89,8 @@
WAL array: On data array%%%
Other notes: Battery-backed write cache and <tt>commit_delay</tt> disabled%%%
<pre>
- scaling factor: 100
- number of clients: 100
- number of transactions per client: 50
- number of transactions actually processed: 5000/5000
- tps = 50.434271 (including connections establishing)
- tps = 53.195151 (excluding connections establishing)
-
- scaling factor: 600
- number of clients: 100
- number of transactions per client: 500
- number of transactions actually processed: 50000/50000
- tps = 73.665381 (including connections establishing)
- tps = 73.725278 (excluding connections establishing)
-
scaling factor: 600
number of clients: 100
number of transactions per client: 500
number of transactions actually processed: 50000/50000
@@ -162,27 +101,20 @@
* Data array: RAID1, 2x 72GB 10k RPM%%%
WAL array: RAID1, 2x 72GB 10k RPM%%%
<pre>
- scaling factor: 100
+ scaling factor: 600
number of clients: 100
number of transactions per client: 1000
number of transactions actually processed: 100000/100000
- tps = 217
.737758
(including connections establishing)
- tps = 220
.277597
(excluding connections establishing)
+ tps = 131
.213838
(including connections establishing)
+ tps = 131
.309052
(excluding connections establishing)
</pre>
* Data array: RAID1+0, 4x 72GB 15k RPM%%%
WAL array: On data array%%%
<pre>
- scaling factor: 100
- number of clients: 100
- number of transactions per client: 1000
- number of transactions actually processed: 100000/100000
- tps = 325.140579 (including connections establishing)
- tps = 330.843403 (excluding connections establishing)
-
scaling factor: 600
number of clients: 100
number of transactions per client: 1000
number of transactions actually processed: 100000/100000
@@ -193,15 +125,8 @@
* Data array: RAID5, 4x 72GB 15k RPM%%%
WAL array: On data array%%%
<pre>
- scaling factor: 100
- number of clients: 100
- number of transactions per client: 1000
- number of transactions actually processed: 100000/100000
- tps = 192.430583 (including connections establishing)
- tps = 194.404205 (excluding connections establishing)
-
scaling factor: 600
number of clients: 100
number of transactions per client: 1000
number of transactions actually processed: 100000/100000
@@ -212,15 +137,8 @@
* Data array: RAID1, 2x 72GB 15k RPM%%%
WAL array: RAID1, 2x 72GB 15k RPM%%%
<pre>
- scaling factor: 100
- number of clients: 100
- number of transactions per client: 1000
- number of transactions actually processed: 100000/100000
- tps = 263.185661 (including connections establishing)
- tps = 266.928392 (excluding connections establishing)
-
scaling factor: 600
number of clients: 100
number of transactions per client: 1000
number of transactions actually processed: 100000/100000
@@ -233,15 +151,8 @@
* Data array: RAID1+0, 4x 72GB 15k RPM%%%
WAL array: RAID1, 2x 72GB 10k RPM%%%
<pre>
- scaling factor: 100
- number of clients: 100
- number of transactions per client: 2000
- number of transactions actually processed: 200000/200000
- tps = 409.561669 (including connections establishing)
- tps = 414.078634 (excluding connections establishing)
-
scaling factor: 600
number of clients: 100
number of transactions per client: 1000
number of transactions actually processed: 100000/100000
@@ -252,15 +163,8 @@
* Data array: RAID5, 4x 72GB 15k RPM%%%
WAL array: RAID1, 2x 72GB 10k RPM%%%
<pre>
- scaling factor: 100
- number of clients: 100
- number of transactions per client: 1000
- number of transactions actually processed: 100000/100000
- tps = 276.581309 (including connections establishing)
- tps = 280.727719 (excluding connections establishing)
-
scaling factor: 600
number of clients: 100
number of transactions per client: 1000
number of transactions actually processed: 100000/100000
