Differences between version 10 and predecessor to the previous major change of PgBench.
Other diffs: Previous Revision, Previous Author, or view the Annotated Edit History
Newer page: | version 10 | Last edited on Thursday, June 15, 2006 5:00:16 pm | by GuyThornley | Revert |
Older page: | version 3 | Last edited on Thursday, June 15, 2006 4:11:18 pm | by PerryLorier | Revert |
@@ -12,8 +12,12 @@
checkpoint_warning = 300
commit_delay = 20000
commit_siblings = 3
wal_sync_method = fdatasync
+
+ enable_seqscan = off
+ default_with_oids = off
+ stats_start_collector = false
</verbatim>
Exceptions will be listed as the tests are performed.
@@ -24,13 +28,15 @@
The base hardware is:
HP DL380 G4%%%
Dual 3.20GHz Xeon, 1MB L2 cache, 800MHz FSB, Hyperthreading disabled%%%
- 1GB DDR
-333
(PC2700
) registered ECC memory%%%
+ 1GB DDR2
-400
(PC2-3200
) registered ECC memory%%%
Broadcom PCI-X onboard network adapters%%%
+ ~SmartArray 6i onboard
Battery-backed write cache enabled.
- Linux 2.4.27 (from Debian <tt>kernel-image-2.4.27-2-686-smp</tt>)
+ Linux 2.4.27 (from Debian <tt>kernel-image-2.4.27-2-686-smp</tt>)%%%
+ Using ext3 with 'ordered' data mode
On with the testing!
----
@@ -120,8 +126,23 @@
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%%%
+Other notes: %%%
+
+ <pre>
+ scaling factor: 100
+ number of clients: 100
+ number of transactions per client: 2000
+ number of transactions actually processed: 200000/200000
+ tps = 353.380160 (including connections establishing)
+ tps = 356.704753 (excluding connections establishing)
</pre>
----