Re: Better Unilization of Memory

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Better Unilization of Memory
Дата
Msg-id 87d6bpqv7n.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на Better Unilization of Memory  (Lynn.Tilby@asu.edu)
Ответы Re: Better Unilization of Memory  (Lynn.Tilby@asu.edu)
Список pgsql-general
Lynn.Tilby@asu.edu writes:

> In looking at top, I have noticed when doing some
> long queries that RAM memory is only being used
> at 1-3%.  While, CPU often jumps to 97, 98, even
> 99% utilization (which is great!).
>
> Is this normal for RAM utilization?

It depends on what you have set shared_buffers to in your
postgresql.conf file.  If you have not tuned this value yet you should
do so as the default setting is very conservative.

There is a lot of discussion on appropriate shared_buffers settings if
you search the mailing list archives...

-Doug

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

Предыдущее
От: Lynn.Tilby@asu.edu
Дата:
Сообщение: AUTOCOMMIT didn't work...
Следующее
От: Troels Arvin
Дата:
Сообщение: Re: offset for query result ??