| From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: New to PostgreSQL, performance considerations |
| Date: | 2006-12-12 06:35:04 |
| Message-ID: | Pine.GSO.4.64.0612120118340.10640@westnet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, 11 Dec 2006, Michael Stone wrote:
> Can anyone else reproduce these results? I'm on similar hardware (2.5GHz P4,
> 1.5G RAM)...
There are two likely candidates for why Daniel's P4 3.0GHz significantly
outperforms your 2.5GHz system.
1) Most 2.5GHZ P4 processors use a 533MHz front-side bus (FSB); most
3.0GHZ ones use an 800MHz bus.
2) A typical motherboard paired with a 2.5GHz era processor will have a
single-channel memory interface; a typical 3.0GHZ era board supports
dual-channel DDR.
These changes could easily explain the magnitude of difference in results
you're seeing, expecially when combined with a 20% greater raw CPU clock.
--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-12-12 06:47:28 | Re: New to PostgreSQL, performance considerations |
| Previous Message | Christopher Browne | 2006-12-12 03:27:46 | Re: New to PostgreSQL, performance considerations |