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?