469,645 Members | 1,569 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

query result set caching

Dear All:

Im looking for solutions (Free Software is better) to do query result
caching.
Thanks to the people from #postgresql I know that postgres doesn't do
that by himself and the solution should be some kind of middle ware.

This is our problem: we are executing the same set of SELECT SP/queries
hundreds of times, without updating the DB. We would like to cache the
result of this SP/queries so the next time somebody runs one of them,
the results come from the cache instead of the db.

We would like to use an already developed and tested solution but if we
can't find anything that fits our needs, we can develop our own solution
(playing w/ PHP and PG's LISTEN/NOTIFY)

Thanks in advance

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBBEUGzhruVGj+ub3MRAsxMAJ91DWjIPBgu22uO9AzgWV UFxCpt8wCgsigd
WlVLDcLkYp1mV2y///zhSBw=
=4NXw
-----END PGP SIGNATURE-----

Nov 23 '05 #1
2 2884
Martin Sarsale <ma****@emepe3.net> wrote:
Dear All:

Im looking for solutions (Free Software is better) to do query result
caching.
Thanks to the people from #postgresql I know that postgres doesn't do
that by himself and the solution should be some kind of middle ware.

This is our problem: we are executing the same set of SELECT SP/queries
hundreds of times, without updating the DB. We would like to cache the
result of this SP/queries so the next time somebody runs one of them,
the results come from the cache instead of the db.

We would like to use an already developed and tested solution but if we
can't find anything that fits our needs, we can develop our own solution
(playing w/ PHP and PG's LISTEN/NOTIFY)


There was a lot of talk about "materialized views" not too many months ago
on one of the PostgreSQL lists. I believe these techniques can accomplish
what you're looking for. An archive or google search should turn up
lots of info.

HTH.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #2
On Wednesday 04 August 2004 1:06 pm, Martin Sarsale wrote:
Dear All:

Im looking for solutions (Free Software is better) to do query
result caching.
Thanks to the people from #postgresql I know that postgres doesn't
do that by himself and the solution should be some kind of middle
ware.

This is our problem: we are executing the same set of SELECT
SP/queries hundreds of times, without updating the DB. We would
like to cache the result of this SP/queries so the next time
somebody runs one of them, the results come from the cache instead
of the db.


Possible kludge that may or may not help in your situation:

Can you create a table that is the result of your query and have the
front-end select from that? You could even create a trigger to update
the result table whenever the source table(s) are altered.

Cheers,
Steve
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by aaron | last post: by
2 posts views Thread by Yonatan Goraly | last post: by
6 posts views Thread by Steven D.Arnold | last post: by
8 posts views Thread by Evan Smith | last post: by
4 posts views Thread by Hermann | last post: by
reply views Thread by =?Utf-8?B?UmF2aQ==?= | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.