Re: Issues of slow running queries when dealing with Big Data

[Michael Lewis <mlewis@xxxxxxxxxxx>]

On Tue, Jul 28, 2020 at 7:59 AM Shaozhong SHI <shishaozhong@xxxxxxxxx> wrote:

Hi, Gavin,

PostgreSQL Version - 10.11. PostGIS Version - 2.4.7. Operating System - Red Hat Enterprise Linux 7.7 .

That is all I know at the moment.

As I understand, our IT staff is building another one to sit on Azure.

Please don't top-post in these mailing lists.

Can you share the results of the below?

select name, setting, source from pg_settings where source <> 'default';