Re: CPUs for new databases - Mailing list pgsql-performance

From Josh Berkus
Subject Re: CPUs for new databases
Date
Msg-id 4CC73FEF.9020805@agliodbs.com
Whole thread Raw
In response to Re: CPUs for new databases  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: CPUs for new databases
List pgsql-performance
On 10/26/10 7:50 AM, Scott Marlowe wrote:
> For faster but fewer individual cores the Intels are pretty good.  For
> way more cores, each being pretty fast and having enough memory
> bandwidth to use all those cores, the AMDs are very impressive.  The
> Magny Cours AMDs are probably the best 4 socket cpus made.

In a general workload, fewer faster cores are better.  We do not scale
perfectly across cores.  The only case where that's not true is
maintaining lots of idle connections, and that's really better dealt
with in software.

So I've been buying Intel for the last couple years.  Would love to see
some testing on database workloads.

--
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Next
From: Mladen Gogala
Date:
Subject: Re: Postgres insert performance and storage requirement compared to Oracle