Differences between version 19 and previous revision of PgBench.
Other diffs: Previous Major Revision, Previous Author, or view the Annotated Edit History
Newer page: | version 19 | Last edited on Thursday, June 15, 2006 9:24:35 pm | by GuyThornley | Revert |
Older page: | version 18 | Last edited on Thursday, June 15, 2006 9:17:59 pm | by GuyThornley | Revert |
@@ -40,9 +40,9 @@
* Using [Ext3] with <tt>ordered</tt> data mode
On with the testing!
-!! Results
+!! Results: 4-disk configurations
* Data array: RAID5, 4x 72GB 10k RPM%%%
WAL array: On data array%%%
@@ -102,20 +102,8 @@
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)
- </pre>
-
-* 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)
</pre>
* Data array: RAID1+0, 4x 72GB 15k RPM%%%
WAL array: On data array%%%
@@ -127,21 +115,8 @@
number of transactions actually processed: 100000/100000
tps = 325.140579 (including connections establishing)
tps = 330.843403 (excluding connections establishing)
</pre>
-
-* 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 = 236.721312 (including connections establishing)
- tps = 239.738377 (excluding connections establishing)
- </pre>
-
* Data array: RAID5, 4x 72GB 15k RPM%%%
WAL array: On data array%%%
<pre>
@@ -162,8 +137,34 @@
number of transactions per client: 500
number of transactions actually processed: 50000/50000
tps = 179.163723 (including connections establishing)
tps = 182.671524 (excluding connections establishing)
+ </pre>
+
+!! Results: 6-disk configurations
+
+* 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)
+ </pre>
+
+* 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 = 236.721312 (including connections establishing)
+ tps = 239.738377 (excluding connections establishing)
</pre>
* Data array: %%%
WAL array: %%%