Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]

From: Arjen van der Meijden
Subject: Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]
Date: ,
Msg-id: 45EBF658.30907@tweakers.net
(view: Whole thread, Raw)
In response to: Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Arjen van der Meijden)
Responses: Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Stefan Kaltenbrunner)
Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Richard Huxton)
List: pgsql-performance

Tree view

[kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  ("Jim C. Nasby", )
 Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Alvaro Herrera, )
  Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Arjen van der Meijden, )
   Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Arjen van der Meijden, )
    Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Stefan Kaltenbrunner, )
     Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Arjen van der Meijden, )
      Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Stefan Kaltenbrunner, )
       Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Tom Lane, )
        Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Arjen van der Meijden, )
        Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Stefan Kaltenbrunner, )
    Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Richard Huxton, )
  Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Scott Marlowe, )

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
>


pgsql-performance by date:

From: Heikki Linnakangas
Date:
Subject: Re: PostgreSQL 8.2.3 VACUUM Timings/Performance
From: Stefan Kaltenbrunner
Date:
Subject: Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]