[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