[postgis-users] Issues of slow running queries when dealing with Big Data

[Shaozhong SHI]

It has been found that issues occur when Big Data is being handled with
PostGIS.  Typically, queries can be killed by the system or memory is out.
Often, queries can be very slow.  Sometimes, it will take days or weeks to
complete.

What are the best approaches and means for improving the performance of
queries and processes in PostgreSQL/PostGIS?

Can anyone shed light on this?

Regards,

Shao
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200727/b4f50b4f/attachment.html>