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

[Marc Jacquin]

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.

 

Thx.

 

Marc

 

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