On 28/07/2020 22:54, Shaozhong SHI wrote:
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
Probably helps if you can give us more details!
Such as O/S, versions of PostgreSQL/PostGIS, and hardware used. Plus
anything else you think might be relevant.
Cheers,
Gavin
