Re: Architecting a database - Mailing list pgsql-performance

From Ben Chobot
Subject Re: Architecting a database
Date
Msg-id 042F230C-09C9-45D0-98ED-01009721F1F8@silentmedia.com
Whole thread Raw
In response to Re: Architecting a database  (tony@exquisiteimages.com)
List pgsql-performance
On Jun 30, 2010, at 11:12 AM, tony@exquisiteimages.com wrote:

>  I read a post
> earlier today that mentioned in passing that it was better to have a
> faster processor than more cores.

This really depends on your workload and how much you value latency vs. throughput. If you tend to have a lot of very
simplequeries, more cores => more throughput, and it may not matter much if your queries take 20ms or 30ms if you can
bedoing a dozen or two more of them concurrently in an AMD system than in an Intel one. On the other hand, if you have
lessclients, or more latency-sensitive clients, then fewer-but-faster cores is usually a win. 

Either way, the amount of power you can get for your money is pretty impressive.

pgsql-performance by date:

Previous
From: Jignesh Shah
Date:
Subject: Re: PostgreSQL as a local in-memory cache
Next
From: Bruce Momjian
Date:
Subject: Re: Analysis Function