Re: How to keep a table in memory?

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: How to keep a table in memory?
Дата
Msg-id 473A21B8.2070303@enterprisedb.com
обсуждение исходный текст
Ответ на Re: How to keep a table in memory?  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Список pgsql-hackers
Ron Mayer wrote:
> Heikki Linnakangas wrote:
>> Luke Lonergan wrote:
>>> Vacuum is a better thing to run, much less CPU usage.
>> Vacuum is actually not good for this purpose, because it's been
>> special-cased to not bump the usage count.
> 
> Though the OS's page cache will still see it as accesses, no?

Yes, if the pages were not already in shared buffers.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Ron Mayer
Дата:
Сообщение: Re: How to keep a table in memory?
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Simplifying Text Search