Re: PostgreSQL and Xeon MP

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Sven Geisler" <sgeisler(at)aeccom(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL and Xeon MP
Date: 2006-03-16 16:05:38
Message-ID: 1d4e0c10603160805n6d727a94ic2ab0ed0bcf56c1a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 3/16/06, Sven Geisler <sgeisler(at)aeccom(dot)com> wrote:
> Did you compare 7.4 on a 4-way with 8.1 on a 2-way?

I know there are too many parameters changing between the two servers
but I can't really change anything before tuesday. On tuesday, we will
be able to compare both servers with the same software.

> How many queries and clients did you use to test the performance?

Googlebot is indexing this site generating 2-3 mbits/s of traffic so
we use the googlebot to stress this server. There was a lot of clients
and a lot of queries.

> How much faster is the XEON DP?

Well, on high load, PostgreSQL scales well on the DP (load at 40,
queries slower but still performing well) and is awfully slow on the
MP box.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Guillaume Smet 2006-03-16 16:08:46 Re: PostgreSQL and Xeon MP
Previous Message Tom Lane 2006-03-16 15:57:01 Re: BETWEEN optimizer problems with single-value