Re: Free Cache Memory (Linux) and Postgresql

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Free Cache Memory (Linux) and Postgresql
Дата
Msg-id dcc563d10809301605m4f40bf3cqd635bf3164fbf724@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Free Cache Memory (Linux) and Postgresql  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
On Tue, Sep 30, 2008 at 4:02 PM, Martijn van Oosterhout
<kleptog@svana.org> wrote:
> On Tue, Sep 30, 2008 at 03:51:44PM +0200, Denis Gasparin wrote:
>> It seems like postgres or the operating system (linux) is keeping in
>> cache that old data even if it has been deleted.
>
> Just remember: "free memory" is "memory you paid for and are not
> using" == "wasted memory". The OS knows damn well it's not important
> and will throw it out if necessary, but it costs nothing to keep it.

free
             total       used       free     shared    buffers     cached
Mem:      33031252   24901824    8129428          0     380492   21991100

shhhhh.  don't tell me boss we've got 8 gig free in the db servers,
he'll want to re-purpose it.

Still 20+ Gig of cache is awfully nice.

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Why Does UPDATE Take So Long?
Следующее
От: Chris
Дата:
Сообщение: Re: MySQL to Postgresql schema conversion