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