Whenever geospatial functions such as St_intersects or recursive query used, the PostGIS appears to spawn away to many child queries and just obliterate the CPU. Nothing finishes.
That forced me to try out to do the some tasks on the FME server. I tried to use this http://blog.cleverelephant.ca/2010/07/network -walking-in-postgis.html in the PostGIS. I tried to linecombiner in FME. LineCombiner | FME (safe.com) <https://www.safe.com/transformers/line-combiner/>. With a large data set, the running of processors were monitored. It was estimated the PostGIS one would take 16 days to complete. But, it only took a few minute to do the same thing in FME. This suggests that something is not right with the PostGIS Server. Have anyone got experience with configuration and improving perfomance of PostGIS Server? Regards, David
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users