Message-ID: <43425A0E.2050305@foo.at>
Date: Tue, 04 Oct 2005 12:31:42 +0200
From: Stefan Weiss <spaceman@foo.at>
Organization: Foo Orbital Operations
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Is There Any Way ....
References: <EKEMKEFLOMKDDLIALABIMECFCDAA.lvaningen@esncc.com>
In-Reply-To: <EKEMKEFLOMKDDLIALABIMECFCDAA.lvaningen@esncc.com>
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 7bit

On 2005-09-30 01:21, Lane Van Ingen wrote:
>   (3) Assure that a disk-based table is always in memory (outside of keeping
> it in
>       memory buffers as a result of frequent activity which would prevent
> LRU
>       operations from taking it out) ?

I was wondering about this too. IMO it would be useful to have a way to tell
PG that some tables were needed frequently, and should be cached if
possible. This would allow application developers to consider joins with
these tables as "cheap", even when querying on columns that are not indexed.
I'm thinking about smallish tables like users, groups, *types, etc which
would be needed every 2-3 queries, but might be swept out of RAM by one
large query in between. Keeping a table like "users" on a RAM fs would not
be an option, because the information is not volatile.


cheers,
stefan