From: Chris Travers <chris@metatrontech.com>
To: Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Tsirkin Evgeny <tsurkin@jct.ac.il>
Cc: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: caching table/query
Date: Tue, 19 Jul 2005 23:16:12 -0700
Message-ID: <42DDEC2C.9050009@metatrontech.com> (raw)
In-Reply-To: <42DB4DE2.6090304@mail.jct.ac.il>
References: <42DA3A4C.3080009@mail.jct.ac.il>
<20050717140655.GA9637@winnie.fuhr.org>
<42DA7226.5070808@mail.jct.ac.il>
<28088.1121615607@sss.pgh.pa.us>
<42DB4DE2.6090304@mail.jct.ac.il>
Tsirkin Evgeny wrote:
>
> Well i guess that there are cases where that is not so.However i
> understand that postgres does not have any way accept
> the automatic.
Largely true. There may be ways of forcing a from-memory query once the
system is in place, but I am not sure that this is always what you want,
it would not be pretty, and might have some real performance issues. My
suggestion is that you wait until your system is in operation and then
look first for general tuning help before you even consider trying to
impliment a memory-cached table in your application.
Just for the record, I can think of at least one way of hacking this on,
but it seems like it should be an absolutely last resort rather than a
first impulse.
PostgreSQL can do this, but you probably don't want it to.
Best Wishes,
Chris Travers
Attachments:chris.vcf (text/x-vcard, 125B) download
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:chris@metatrontech.com
x-mozilla-html:FALSE
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: chris@metatrontech.com, tsurkin@mail.jct.ac.il, tgl@sss.pgh.pa.us, tsurkin@jct.ac.il, mike@fuhr.org
Subject: Re: caching table/query
In-Reply-To: <42DDEC2C.9050009@metatrontech.com>
References: <42DA3A4C.3080009@mail.jct.ac.il> <20050717140655.GA9637@winnie.fuhr.org> <42DA7226.5070808@mail.jct.ac.il> <28088.1121615607@sss.pgh.pa.us> <42DB4DE2.6090304@mail.jct.ac.il> <42DDEC2C.9050009@metatrontech.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox