[postgis-devel] ST_Envelope & spatial index

Sandro Santilli strk at keybit.net
Tue Mar 13 15:46:19 PDT 2012


On Tue, Mar 13, 2012 at 11:07:24PM +0100, Andrea Peri wrote:

> select ST_Extent(ST_Envelope(rast)) from tabella;
> 
> But it take many time, too time I guess.

I think it'll fully decompress each value.
If that's the case it could be optimized by only fetching
the header instead.

--strk;

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'




More information about the postgis-devel mailing list