| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Matthew Peter <survivedsushi(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: named cache |
| Date: | 2006-12-01 10:16:05 |
| Message-ID: | 457000E5.7010306@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Matthew Peter wrote:
> Is it possible to put an query result into memory? Like SELECT * from table WHERE
> [...] CACHE cache_name TIMEOUT '1 hour'::interval; So if "cache_name" exists with
> the same SQL statement, the result would be fetched from the cache, refreshing and
> updating the cache with fresh results when it expires? Reducing disk reads, query
> times, etc.
No. That's not something PG does internally.
Sounds like you might want to look at memcached/pgmemcached.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2006-12-01 10:22:15 | Re: Separation of clients' data within a database |
| Previous Message | Richard Huxton | 2006-12-01 09:40:38 | Re: initdb problem on Windows XP Home |