Dear group,
I've been having trouble trying to do a nested PostGIS query on our system.
The query looks something like this:
SELECT count, geometry, ST_GeometryType(geometry)
FROM (
SELECT COUNT(*) AS count,
ST_Buffer(ST_Buffer(ST_Union(ST_Buffer(ST_SimplifyPreserveTopology(geometry,
0.001), 1e-005)),.001), -.001) AS geometry
FROM <table>
WHERE <criteria>
ORDER BY ST_GeoHash(geometry, 8), <other_fields>
LIMIT <limit> OFFSET <offset>
)
) AS i
;
This query has worked well for us numerous times, but is not working with
this particular set of geometries. We have our <limit> set to 500000. The
types of errors we receive look like one of these:
server closed the connection unexpectedly
The connection to the server was lost. Attempting reset: Failed.
I have been able to run this query successfully by paring down my limit to
10000. As I mentioned above, it has worked well for us with sizes as large
as 500000. We are running PostGIS 1.5.3 on Postgers 9.0.4 on 64-bit Linux.
Any ideas what might be happening here?
*Yusuf Siddiqui *
*ASPRS CMS #R149-RS
Senior Solutions Engineer
****i-cubed : information integration & imaging LLC
*1600 Prospect Park Way
Ft. Collins, CO 80525
Email: ysiddi...@i3.com
Voice: +1-970-482-4400
Fax: +1-970-482-4499
Web: www.i3.com
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
