pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (9+ messages)  latest in thread

Message-ID: <42DDEC2C.9050009@metatrontech.com>
Permalink:  ../42DDEC2C.9050009@metatrontech.com/
Also on:    postgresql.org/message-id/42DDEC2C.9050009@metatrontech.com

 · 

reply

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