[postgis-users] ST_Extent of table

Javier de la Torre jatorre at vizzuality.com
Mon Sep 19 10:11:18 PDT 2011


Thanks Paul!

Really sorry I did not find it myself, shame on me. :(


Javier de la Torre
@jatorre

Vizzuality
148 Lafayette St. PH, New York, 10013,USA
Hortaleza 48 1, 28004,Madrid,Spain
+1 347 320 7715
+34 689 41 4420
www.vizzuality.com
@vizzuality




On Sep 19, 2011, at 1:06 PM, Paul Ramsey wrote:

> Javier,
> You can get a fast, imprecise extent from st_estimated_extent. We
> should update/change it to use the index top page, but for now it uses
> the index stats, which means it is sometimes slightly underdetermined,
> so you might need to grow it by 10-25% depending on your use case.
> Paul
> 
> On Mon, Sep 19, 2011 at 9:29 AM, Javier de la Torre
> <jatorre at vizzuality.com> wrote:
>> Hi all,
>> I need to calculate the extent of a full table. My understanding is that
>> this function will do a full scan of the table to calculate it. Is it
>> possible to get the extent of the table from the index somehow so that is
>> not needed to scan the full table? I also dont need it very precise if that
>> helps in any way.
>> Thanks!
>> 
>> Javier de la Torre
>> @jatorre
>> Vizzuality
>> 148 Lafayette St. PH, New York, 10013,USA
>> Hortaleza 48 1, 28004,Madrid,Spain
>> +1 347 320 7715
>> +34 689 41 4420
>> www.vizzuality.com
>> @vizzuality
>> 
>> 
>> 
>> 
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> 
>> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110919/b0486f08/attachment.html>


More information about the postgis-users mailing list