Re: Hardware - Mailing list pgsql-general

From Ben
Subject Re: Hardware
Date
Msg-id Pine.LNX.4.64.0702061124360.28404@localhost.localdomain
Whole thread Raw
In response to Hardware  (Walter Vaughan <wvaughan@steelerubber.com>)
List pgsql-general
On Tue, 6 Feb 2007, Walter Vaughan wrote:

> <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.

My understanding is that this is no longer true with the newer xeons, but
then, I haven't tested them myself, so I can't say.

pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: PostgreSQL/FireBird
Next
From: "Merlin Moncure"
Date:
Subject: getting status transaction error