<html>
<head>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I'm trying to solve a mistery (and I didn't know is I should post
here or to the the devel list)<br>
<br>
ST_Distance between complex polygons is very slow here, despite the
work done in
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a href="http://boundlessgeo.com/2012/07/making-geography-faster/">http://boundlessgeo.com/2012/07/making-geography-faster/</a>
.. It's taking like 4 seconds.<br>
<br>
Looking harder into this I see there's a _st_distancetree(geo1,
geo2) that completes the task in 171 ms....<br>
<br>
It seems to me that the standard ST_Distance is not using the new
"circular bounding boxes" code...<br>
<br>
So I downloaded the source code and I saw that
geography_distance_cache always fails because GetCircTreeGeomCache
always returns null. I see that a cache is initialized and put into
a "generic cache" array, but then is reset to null in
GetGenericCacheCollection when called from GetPROJ4SRSCache beacuse
"fcinfo->flinfo->fn_extra" is again null... (set in
MemoryContextAllocZero)<br>
<br>
Does this what I am saying make sense? =)<br>
<br>
How is this cache supposed to work?<br>
<br>
Thanks for any help!<br>
<br>
<pre class="moz-signature" cols="72">--
Nicolás.-</pre>
</body>
</html>