[postgis-users] Collecting points for the overall bounding box
marc.jacquin at magellium.fr
Mon Jun 30 06:23:00 PDT 2008
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...
More information about the postgis-users