[postgis-users] Configuration and performance of PostGIS

[Shaozhong SHI]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220422/679a9377/attachment.html>