Issues of slow running queries when dealing with Big Data

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Issues of slow running queries when dealing with Big Data
Date: 2020-07-28 10:54:10
Message-ID: CA+i5Jwb-4O2BGOCPkuCctZ=ggLw94VLuXffKRWzJeranDo96eg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Rowley 2020-07-28 10:57:37 Re: is JIT available
Previous Message Daniel Westermann (DWE) 2020-07-28 08:42:17 Out of memory with "create extension postgis"