Re: Linux mis-reporting memory

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: Linux mis-reporting memory
Дата
Msg-id 1190369325.4661.178.camel@PCD12478
обсуждение исходный текст
Ответ на Re: Linux mis-reporting memory  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: Linux mis-reporting memory  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Re: Linux mis-reporting memory  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-performance
On Fri, 2007-09-21 at 10:43 +0100, Gregory Stark wrote:
> The other possibility is that Postgres just hasn't even touched a large part
> of its shared buffers.
>

But then how do you explain the example I gave, with a 5.5GB table
seq-scanned 3 times, shared buffers set to 12 GB, and top still showing
almost 100% memory as cached and no SWAP "used" ? In this case you can't
say postgres didn't touch it's shared buffers - or a sequential scan
won't use the shared buffers ?

Cheers,
Csaba.



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

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Searching for the cause of a bad plan
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: Linux mis-reporting memory