[ discussion of server side result caching ]

and lets not forget PG's major fork it will throw into things: MVCC
The results of query A may hold true for txn 1, but not txn 2 and so on .
That would have to be taken into account as well and would greatly complicate things.


It is always possible to do a "poor man"'s query cache with triggers.. which would just leave you with basically a materialized view.

--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/


---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to