[postgis-devel] Caching function calls with CTEs

Paragon Corporation lr at pcorp.us
Fri Jul 17 13:25:08 PDT 2009


We tried CTEs against that annoying issue of functions not being cached in
the same row.  Preliminary tests seem to suggest it might be the ideal
solution for this.
We suspect it will also be good in many other scenarios where the planner
refuses to use indexes in the right order etc.


We are going to test with real spatial queries next in preparation for our
OSCON presentation next week.

Sadly it looks like we probably won't have 1.4 out in time for our
presentation  - oh well :(

Anyrate take a look and test with your data to see if it speeds up your

L & R

More information about the postgis-devel mailing list