Re: Hardware

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

In response to

  • Hardware at 2007-02-06 15:59:21 from Walter Vaughan

Responses

Browse pgsql-general by date

  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