| From: | Ben Chobot <bench(at)silentmedia(dot)com> |
|---|---|
| To: | tony(at)exquisiteimages(dot)com |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Architecting a database |
| Date: | 2010-06-30 18:18:33 |
| Message-ID: | 042F230C-09C9-45D0-98ED-01009721F1F8@silentmedia.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Jun 30, 2010, at 11:12 AM, tony(at)exquisiteimages(dot)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 simple queries, more cores => more throughput, and it may not matter much if your queries take 20ms or 30ms if you can be doing a dozen or two more of them concurrently in an AMD system than in an Intel one. On the other hand, if you have less clients, 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jignesh Shah | 2010-06-30 18:21:42 | Re: PostgreSQL as a local in-memory cache |
| Previous Message | tony | 2010-06-30 18:12:27 | Re: Architecting a database |