[postgis-users] Collecting points for the overall bounding box

Marc Jacquin marc.jacquin at magellium.fr
Mon Jun 30 06:23:00 PDT 2008

Hi all,


The request is quite simple, something like:


SELECT box2d(collect(transform(wkb_geometry,4326))) FROM mytable


Mytable contains about 100000 records of a point type geometry. A GIST index
is available for the table but it takes several minutes on a respectable
recent dual-core with 4 Gb of RAM. 


Any idea would be helpful.






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

More information about the postgis-users mailing list