pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Arjen van der Meijden <acmmailing@tweakers.net>
To: pgsql-performance@postgresql.org
Subject: Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]
Date: Mon, 05 Mar 2007 11:52:08 +0100
Message-ID: <45EBF658.30907@tweakers.net> (raw)
In-Reply-To: <45E84790.6050609@tweakers.net>
References: <20070227182621.GE29041@decibel.org>
	<20070302150129.GF4885@alvh.no-ip.org>
	<45E84790.6050609@tweakers.net>

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
> 



view thread (11+ messages)  latest in thread

Message-ID: <45EBF658.30907@tweakers.net>
Permalink:  ../45EBF658.30907@tweakers.net/
Also on:    postgresql.org/message-id/45EBF658.30907@tweakers.net

 · 

reply

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: acmmailing@tweakers.net
  Subject: Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]
  In-Reply-To: <45EBF658.30907@tweakers.net>

* 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