On Tue, Jan 27, 2009 at 7:03 AM, M. Edward (Ed) Borasky
> 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.
In response to
pgsql-performance by date
|Next:||From: Kevin Traster||Date: 2009-01-29 07:01:34|
|Subject: NOT IN >2hrs vs EXCEPT < 2 sec.|
|Previous:||From: Scott Marlowe||Date: 2009-01-28 20:01:50|
|Subject: Re: [PERFORMANCE] Buying hardware|