[postgis-devel] lwgeom_calculate_bbox

Sandro Santilli strk at keybit.net
Sun Mar 20 10:18:09 PDT 2011


Checking some more by myself I've found that
ST_Envelope is returning the double precision box
while the cached box is in single-precision.

That should explain...

But, aren't we using ST_Envelope for speeding up
Rasters queries ? If we're going to drop the BOX2D
type, how else would we go with fetching a cached BOX ?
Should we cache a full box and only strip-down in indices,
if at all ?

--strk;

On Sun, Mar 20, 2011 at 06:01:21PM +0100, Sandro Santilli wrote:
> I was looking at ST_Envelope implementation to see how much
> speed juice we could extract from it and found thi code:
> 
>  LWGEOM *lwgeom = pglwgeom_deserialize(geom);
>  if ( lwgeom_calculate_gbox(lwgeom, &box) == LW_FAILURE )
>  ...
> 
> Did something change about cached bboxes ?
> Or, why are we blindly computing that again w/out even checking
> if a cache exist already ?
> 
> I kind of recall we had a get_bbox(lwgeom*) or something which would
> either return the cache or compute a new one...
> 
> Can anyone shed a light on this issue ?
> 
> TIA
> 
> --strk; 
> 
>   ()   Free GIS & Flash consultant/developer
>   /\   http://strk.keybit.net/services.html
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel

-- 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html



More information about the postgis-devel mailing list