Re: How to keep a table in memory?

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: How to keep a table in memory?
Date: 2007-11-13 22:14:16
Message-ID: 473A21B8.2070303@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2007-11-14 02:18:07 Re: Simplifying Text Search
Previous Message Kevin Grittner 2007-11-13 21:23:59 Re: How to keep a table in memory?