Skip site navigation (1) Skip section navigation (2)

Re: caching table/query

From: Chris Travers <chris(at)metatrontech(dot)com>
To: Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tsirkin Evgeny <tsurkin(at)jct(dot)ac(dot)il>,Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: caching table/query
Date: 2005-07-20 06:16:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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

Attachment: chris.vcf
Description: text/x-vcard (127 bytes)

In response to


pgsql-admin by date

Next:From: imiDate: 2005-07-20 06:28:25
Subject: Re: PGSQL 7.4.8 : idle in transaction problem
Previous:From: Peter EisentrautDate: 2005-07-20 06:09:56
Subject: Re: can not start the postgresql, i use gentoo

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group