Postgres Pro
Downloads
Home   >   mailing lists

Issues of slow running queries when dealing with Big Data - Mailing list pgsql-general

From Shaozhong SHI
Subject Issues of slow running queries when dealing with Big Data
Date
Msg-id CA+i5Jwb-4O2BGOCPkuCctZ=ggLw94VLuXffKRWzJeranDo96eg@mail.gmail.com
Whole thread Raw
Responses Re: Issues of slow running queries when dealing with Big Data
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "Daniel Westermann (DWE)"
Date:
Subject: Out of memory with "create extension postgis"
Next
From: David Rowley
Date:
Subject: Re: is JIT available