Re: Hardware - Mailing list pgsql-general

From Lars Heidieker
Subject Re: Hardware
Date
Msg-id 4883152D-113A-4E4F-AABE-2C59C33D08F6@heidieker.de
Whole thread Raw
In response to Hardware  (Walter Vaughan <wvaughan@steelerubber.com>)
Responses Re: Hardware
List 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@heidieker.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-----

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: PostgreSQL/FireBird
Next
From: Richard Huxton
Date:
Subject: Re: Postgres SQL Syntax