[postgis-devel] ST_Envelope & spatial index

[dustymugs]

On 03/13/2012 03:29 PM, Andrea Peri wrote:
>> By the looks of your use of raster2pgsql arguments, the maximum extent
>> constraint was applied.  So, just use
>>
>> SELECT extent FROM raster_columns WHERE r_table_schema = 'my_schema' AND
>> r_table_name = 'ofc10k_2010' AND r_raster_column = 'rast';
>>
>> -bborie
>
>
> Thx, bborie.
>
> It is super fast.
>

It's fast because it is cached due to the maximum extent constraint on 
that table.

-bborie