Received-SPF: none (smeagol.cambrium.nl: domain of acmmailing@tweakers.net
	does not designate permitted sender hosts)
Message-ID: <45EBF658.30907@tweakers.net>
Date: Mon, 05 Mar 2007 11:52:08 +0100
From: Arjen van der Meijden <acmmailing@tweakers.net>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: [kris@obsecurity.org: Progress on scaling of FreeBSD
	on 8 CPU systems]
References: <20070227182621.GE29041@decibel.org>
	<20070302150129.GF4885@alvh.no-ip.org>
	<45E84790.6050609@tweakers.net>
In-Reply-To: <45E84790.6050609@tweakers.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

And here is that latest benchmark we did, using a 8 dual core opteron 
Sun Fire x4600. Unfortunately PostgreSQL seems to have some difficulties 
scaling over 8 cores, but not as bad as MySQL.

http://tweakers.net/reviews/674

Best regards,

Arjen

Arjen van der Meijden wrote:
> Alvaro Herrera wrote:
>> Interesting -- the MySQL/Linux graph is very similar to the graphs from
>> the .nl magazine posted last year.  I think this suggests that the
>> "MySQL deficiency" was rather a performance bug in Linux, not in MySQL
>> itself ...
> 
> The latest benchmark we did was both with Solaris and Linux on the same 
> box, both showed such a drop. So I doubt its "not in MySQL", although it 
> might be possible to fix the load MySQL's usage pattern poses on a 
> system, via the OS. And since MySQL 5.0.32 is less bad than 4.1.22 on 
> that system. We didn't have time to test 5.0.25 again, but .32 scaled 
> better, so at least some of the scaling issues where actually fixed in 
> MySQL itself.
> 
> Best regards,
> 
> Arjen
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
> 
>                http://www.postgresql.org/about/donate
>