Re: How to keep a table in memory?

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Subject: Re: How to keep a table in memory?
Date: 2007-11-13 21:22:39
Message-ID: 473A159F.8040907@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2007-11-13 21:23:59 Re: How to keep a table in memory?
Previous Message Andrew Sullivan 2007-11-13 20:05:08 Re: How to keep a table in memory?