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

Re: A cache for the results of queries ?

From: William Yu <wyu(at)talisys(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: A cache for the results of queries ?
Date: 2004-02-27 00:40:25
Message-ID: c1m439$2049$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-performance
David Pradier wrote:
> i'd like to know if it exists a system of cache for the results of
> queries.

If you are willing to do this at an application level, you could 
calculate a MD5 for every query you plan to run and then SELECT INTO a 
temporary table that's based on the MD5 sum (e.g. TMP_CACHE_45123). Next 
time somebody runs a query, check to see if that table exists already. 
Then you just have to figure out some way to know when results should be 
expired.

In response to

pgsql-performance by date

Next:From: John AllgoodDate: 2004-02-27 03:07:49
Subject: Re: Database Server Tuning
Previous:From: Dror MatalonDate: 2004-02-26 23:42:46
Subject: Re: FreeBSD config

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