Re: Used Memory

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Used Memory
Дата
Msg-id 435CBC9202000025000001AB@gwmta.wicourts.gov
обсуждение исходный текст
Ответ на Used Memory  ("Christian Paul B. Cosinas" <cpc@cybees.com>)
Ответы Re: Used Memory
Список pgsql-performance
In addition to what Mark pointed out, there is the possibility that a
query
is running which is scanning a large table or otherwise bringing in a
large number of pages from disk.  That would first use up all available
unused cache space, and then may start replacing some of your
frequently used data.  This can cause slowness for some time after the
process which flushed the cache, as pages are reread and recached.

Keep in mind that the cache could be flushed by some external process,
such as copying disk files.

The use of free memory for caching is not slowing you down; but if it
coincides with slowness, it could be a useful clue.

-Kevin


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

Предыдущее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: What gets cached?
Следующее
От: "Craig A. James"
Дата:
Сообщение: Re: Used Memory