From: | Lars Heidieker <lars(at)heidieker(dot)de> |
---|---|
To: | Walter Vaughan <wvaughan(at)steelerubber(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Hardware |
Date: | 2007-02-06 16:33:58 |
Message-ID: | 4883152D-113A-4E4F-AABE-2C59C33D08F6@heidieker.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 6 Feb 2007, at 15:59, Walter Vaughan wrote:
> I need to purchase a new server to put posgresql on that will be
> acting as the DBMS server for Apache ofBiz soon. While googling
> around for performance tweaks I saw this at http://revsys.com/
> writings/postgresql-performance.html
>
> <quote>
> CPUs — The more CPUs the better, however if your database does not
> use many complex functions your money is best spent on a better
> disk subsystem. Also, avoid Intel Xeon processors with PostgreSQL
> as there is a problem with the context switching in these
> processors that gives sub-par performance. Opterons are generally
> accepted as being a superior CPU for PostgreSQL databases.
> </quote>
>
> Is this still true in regards to Xeon's? I was looking at a server
> with Quad Core Xeon 2 5335 @ 2.0GHz.
>
> And at http://www.powerpostgresql.com/PerfList
>
It seems to be outdated. As far as I know it was supposed to warn for
the HyperThreading things.
- --
Viele Grüße,
Lars Heidieker
lars(at)heidieker(dot)de
http://paradoxon.info
- ------------------------------------
Mystische Erklärungen.
Die mystischen Erklärungen gelten für tief;
die Wahrheit ist, dass sie noch nicht einmal oberflächlich sind.
-- Friedrich Nietzsche
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)
iD8DBQFFyK36cxuYqjT7GRYRAmHfAJ0Z9q/a2m4gFreX7pKEOypMn7sikwCdG7sY
V6AznEEqG6cj5Hk32Oya6PI=
=yg4Z
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Hannes Dorbath | 2007-02-06 16:41:43 | Re: Help compile pgmemcache against PG 8.2 |
Previous Message | Tom Lane | 2007-02-06 16:33:49 | Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade |