Re: Architecting a database

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: Architecting a database
Дата
Msg-id 042F230C-09C9-45D0-98ED-01009721F1F8@silentmedia.com
обсуждение исходный текст
Ответ на Re: Architecting a database  (tony@exquisiteimages.com)
Список 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 по дате отправления:

Предыдущее
От: Jignesh Shah
Дата:
Сообщение: Re: PostgreSQL as a local in-memory cache
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Analysis Function