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.