From: Sven Geisler <sgeisler@aeccom.com>
To: Guillaume Smet <guillaume.smet@gmail.com>
Cc: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL and Xeon MP
Date: Thu, 16 Mar 2006 14:11:16 +0100
Message-ID: <441963F4.1010607@aeccom.com> (raw)
In-Reply-To: <1d4e0c10603160428s1a3c1f4cocbe8489634524387@mail.gmail.com>
References: <1d4e0c10603160245n55128e86t35431a339afcf8cc@mail.gmail.com>
<44194A4B.3020106@archonet.com>
<1d4e0c10603160428s1a3c1f4cocbe8489634524387@mail.gmail.com>
Hi Guillaume,
I had a similar issue last summer. Could you please provide details
about your XEON MP server and some statistics (context-switches/load/CPU
usage)?
I tried different servers (x86) with different results. I saw a
difference between XEON MP w/ and w/o EMT64. The memory bandwidth makes
also a difference.
What version of XEON MP does your server have?
Which type of RAM does you server have?
Do you use Hyperthreading?
You should provide details from the XEON DP?
Regards
Sven.
Guillaume Smet schrieb:
> Richard,
>
>> You should be seeing context-switching jump dramatically if it's the
>> "classic" multi-Xeon problem. There's a point at which it seems to just
>> escalate without a corresponding jump in activity.
>
> No we don't have this problem of very high context switching in our
> case even when the database is very slow. When I mean very slow, we
> have pages which loads in a few seconds in the normal case (load
> between 3 and 4) which takes several minutes (up to 5-10 minutes) to
> be generated in the worst case (load at 4 but really bad
> performances).
> If I take a look on our cpu load graph, in one year, the cpu load was
> never higher than 5 even in the worst cases...
>
>> I checked with Tom last week. Thread starts below:
>> http://archives.postgresql.org/pgsql-hackers/2006-02/msg01118.php
>>
>> He's of the opinion that 8.1.3 will be an improvement.
>
> Thanks for pointing me this thread, I searched in -performance not in
> -hackers as the original thread was in -performance. We planned a
> migration to 8.1.3 so we'll see what happen with this version.
>
> Do you plan to test it before next tuesday? If so, I'm interested in
> your results. I'll post our results here as soon as we complete the
> upgrade.
>
> --
> Guillaume
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
--
/This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you are not the intended recipient, you should not
copy it, re-transmit it, use it or disclose its contents, but should
return it to the sender immediately and delete your copy from your
system. Thank you for your cooperation./
Sven Geisler <sgeisler@aeccom.com> Tel +49.30.5362.1627 Fax .1638
Senior Developer, AEC/communications GmbH Berlin, Germany
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sgeisler@aeccom.com, guillaume.smet@gmail.com, dev@archonet.com
Subject: Re: PostgreSQL and Xeon MP
In-Reply-To: <441963F4.1010607@aeccom.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox