| From: | Alexander Staubo <alex(at)purefiction(dot)net> |
|---|---|
| To: | Daniel van Ham Colchete <daniel(dot)colchete(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: New to PostgreSQL, performance considerations |
| Date: | 2006-12-12 11:29:29 |
| Message-ID: | 2FC0D8E7-F8ED-452F-BB13-FB665B516E7F@purefiction.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Dec 11, 2006, at 23:22 , Daniel van Ham Colchete wrote:
> I ran this test at a Gentoo test machine I have here. It's a Pentium 4
> 3.0GHz (I don't know witch P4)
Try cat /proc/cpuinfo.
> TESTS RESULTS
> ==============
On a dual-core Opteron 280 with 4G RAM with an LSI PCI-X Fusion-MPT
SAS controller, I am getting wildly uneven results:
tps = 264.775137 (excluding connections establishing)
tps = 160.365754 (excluding connections establishing)
tps = 151.967193 (excluding connections establishing)
tps = 148.010349 (excluding connections establishing)
tps = 260.973569 (excluding connections establishing)
tps = 144.693287 (excluding connections establishing)
tps = 148.147036 (excluding connections establishing)
tps = 259.485717 (excluding connections establishing)
I suspect the hardware's real maximum performance of the system is
~150 tps, but that the LSI's write cache is buffering the writes. I
would love to validate this hypothesis, but I'm not sure how.
Alexander.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Stone | 2006-12-12 12:30:10 | Re: New to PostgreSQL, performance considerations |
| Previous Message | Guido Neitzer | 2006-12-12 10:34:10 | Re: New to PostgreSQL, performance considerations |