Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres_fdw insert extremely slow - Mailing list pgsql-general

From Tom Lane
Subject Re: postgres_fdw insert extremely slow
Date
Msg-id 494596.1606324345@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres_fdw insert extremely slow  (Mats Julian Olsen <mats@duneanalytics.com>)
Responses Re: postgres_fdw insert extremely slow  (Mats Julian Olsen <mats@duneanalytics.com>)
List pgsql-general
Tree view 
Mats Julian Olsen <mats@duneanalytics.com> writes:
> On 25.11.2020 17:58, Tom Lane wrote:
>> ... Have you tried looking into pg_locks on the
>> remote server while this query is running?

> Thanks Tom, I'll try to spin up a regular Postgres instance on both rds 
> and ec2 and see if that helps. As for the locks, I can not see any 
> blocked activity on the remote server while the query runs.

Another place to check is pg_stat_activity, specifically wait_event_type
and wait_event.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Performance hit if I create multiple DBs on same instance
Next
From: Adrian Klaver
Date:
Subject: Re: INSERT Trigger to check for existing records : Does this do what I hope it is doing?