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.
