Message-ID: <448DE0DB.1020107@planet.tn>
Date: Mon, 12 Jun 2006 23:47:07 +0200
From: Zydoon <fzied@planet.tn>
User-Agent: Thunderbird 1.5.0.2 (X11/20060501)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: scaling up postgres
References: <200606030931.k539V38Y007877@smtp2.planet.net.tn>
	<20060603094355.GA23297@uio.no>
	<1150062140.23423.0.camel@localhost.localdomain>
	<448D3B65.7090709@aeccom.com>
In-Reply-To: <448D3B65.7090709@aeccom.com>
OpenPGP: id=8BE92B3F;
	url=hkp://subkeys.pgp.net
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sven Geisler wrote:
> Hi Mario,
> 
> I did run pgbench on several production servers:
> HP DL585 - 4-way AMD Opteron 875
> HP DL585 - 4-way AMD Opteron 880
> HP DL580 G3 - 4-way Intel XEON MP 3.0 GHz
> FSC RX600 S2 - 4-way Intel XEON MP DC 2.66 GHz
> FSC RX600 - 4-way Intel XEON MP 2.5 GHz
> 
> This test has been done with 8.1.4. I increased the number of clients.
> I attached the result as diagram. I included not all test system but the
> gap between XEON and Opteron is always the same.
> 
> The experiences with production systems were the same. We replaced the
> XEON box with Opteron box with a dramatic change of performance.
> 
> Best regards
> Sven.
> 
> 
> Mario Splivalo schrieb:
>> On Sat, 2006-06-03 at 11:43 +0200, Steinar H. Gunderson wrote:
>>> On Sat, Jun 03, 2006 at 10:31:03AM +0100, fzied@planet.tn wrote:
>>>> I do have 2 identical beasts (4G - biproc Xeon 3.2 - 2 Gig NIC)
>>>> One beast will be apache, and the other will be postgres.
>>>> I'm using httperf/autobench for measurments and the best result I
>>>> can get is that my system can handle a trafiic of almost 1600 New
>>>> con/sec.
>>> What version of PostgreSQL? (8.1 is better than 8.0 is much better
>>> than 7.4.)
>>> Have you remembered to turn HT off? Have you considered Opterons
>>> instead of
>>> Xeons? (The Xeons generally scale bad with PostgreSQL.) What kind of
>>> queries
>>
>> Could you point out to some more detailed reading on why Xeons are
>> poorer choice than Opterons when used with PostgreSQL?
>>
>>     Mario
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
> 
> 
> ------------------------------------------------------------------------
> 
> 
> ------------------------------------------------------------------------
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
Thank you for sharing this.
Coming back to my problem :) A very faithful partner accepted to
gracefully borrow us 3 Pseries (bi-ppc + 2G RAM not more). with linux on
them.
Now I'm trying to make my tests, and I'm not that sure I will make the
switch to the PSeries, since my dual xeon with 4 G RAM can handle 3500
concurrent postmasters consuming 3.7 G of the RAM. I cannot reach this
number on the PSeries with 2 G.

can someone give me advice ?
BTW, I promise, at the end of my tests, I'll publish my report.

- --
Zied Fakhfakh
GPG Key : gpg --keyserver subkeys.pgp.net  --recv-keys F06B55B5
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFEjeDbS1DO7ovpKz8RAnLGAJ96/1ndGoc+HhBvOfrmlQnJcfxa6QCfQK9w
i6/GGUCBGk5pdNUDAmVN5RQ=
=5Mns
-----END PGP SIGNATURE-----