[postgis-users] ST_Extent of table

Javier de la Torre jatorre at vizzuality.com
Mon Sep 19 09:29:36 PDT 2011


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




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


More information about the postgis-users mailing list