Re: Scaling further up

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Scaling further up
Дата
Msg-id 20040315200930.GA2921@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: Scaling further up  ("Anjan Dave" <adave@vantage.com>)
Ответы Re: Scaling further up  (Matt Davies <matt@mattdavies.net>)
Список pgsql-performance
On Fri, Mar 12, 2004 at 06:25:48PM -0500, Anjan Dave wrote:
> We upgraded from 8GB to 12GB RAM a month or so ago, but even in the
> past, I've never seen the system exhaust on it's system cache (~6GB, in
> 'top'), while it's swapping.
>
> Some one had mentioned why not have the entire DB in memory? How do I
> configure that, for knowledge?

You don't.  It'll automatically be in memory if (a) you have enough
memory, (b) you don't have anything else on the machine using the
memory, and (c) it's been read at least one time.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca

В списке pgsql-performance по дате отправления:

Предыдущее
От: Arjen van der Meijden
Дата:
Сообщение: Re: Large CASE-statement is pretty slow?
Следующее
От: "Rosser Schwarz"
Дата:
Сообщение: atrocious update performance