On Tue, Jan 27, 2009 at 7:03 AM, M. Edward (Ed) Borasky <znmeb@xxxxxxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
