Re: How to keep a table in memory? - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: How to keep a table in memory?
Date
Msg-id 473A21B8.2070303@enterprisedb.com
Whole thread Raw
In response to Re: How to keep a table in memory?  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List 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 by date:

Previous
From: Ron Mayer
Date:
Subject: Re: How to keep a table in memory?
Next
From: Simon Riggs
Date:
Subject: Re: Simplifying Text Search