Re: [PERFORMANCE] Buying hardware

On Tue, Jan 27, 2009 at 7:03 AM, M. Edward (Ed) Borasky
<znmeb@cesmail.net> wrote:
> M. Edward (Ed) Borasky wrote:
>> Given large amounts of RAM and only PostgreSQL running in the server,
>> the interesting trade-offs become
>>
>> a. How little memory can you buy without putting your service level
>> agreements at risk?
>>
>> b. How do you allocate the PostgreSQL-specific memory buffers at the
>> expense of the Linux page cache for optimum performance?
>
> c. What do I do with the idle cores? :)
>
> (or, how can I exploit them by changing my database design or the
> PostgreSQL architecture?)

You run as many queries as you have cores at the same time?  If you've
only ever got 1 or 2 queries running at the same time, don't buy so
many extra cores.