Re: [PERFORMANCE] Buying hardware - Mailing list pgsql-performance

From M. Edward (Ed) Borasky
Subject Re: [PERFORMANCE] Buying hardware
Date
Msg-id 497F1432.6010009@cesmail.net
Whole thread Raw
In response to Re: [PERFORMANCE] Buying hardware  ("M. Edward (Ed) Borasky" <znmeb@cesmail.net>)
Responses Re: [PERFORMANCE] Buying hardware  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
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?)

--
M. Edward (Ed) Borasky

I've never met a happy clam. In fact, most of them were pretty steamed.

pgsql-performance by date:

Previous
From: "M. Edward (Ed) Borasky"
Date:
Subject: Re: [PERFORMANCE] Buying hardware
Next
From: david@lang.hm
Date:
Subject: Re: [PERFORMANCE] Buying hardware