[postgis-devel] Caching function calls with CTEs

[nicklas.aven at jordogskog.no]

This is really cool Regina and Leo

It's a new way of thinking for me to to use this recursive thing, but I can see that it is very useful.
I hope I will get some time in the near future to try to understand it better.

Also the windowing functions together with postgis aggregate function will be fun to try.

/Nicklas





2009-07-17 Paragon Corporation  wrote:

Nicklas,
>
>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.
>
>http://www.postgresonline.com/journal/index.php?/archives/127-guid.html
>
>We are going to test with real spatial queries next in preparation for our
>OSCON presentation next week.
>
>http://en.oreilly.com/oscon2009/public/schedule/detail/7859
>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
>queries.
>
>L & R
>
>
>_______________________________________________
>postgis-devel mailing list
>postgis-devel at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-devel
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20090719/d85c926d/attachment.html>