| From: | Mats Julian Olsen <mats(at)duneanalytics(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: postgres_fdw insert extremely slow |
| Date: | 2020-11-25 16:48:50 |
| Message-ID: | 10df210c-a1bb-f909-9a48-61ac54880df0@duneanalytics.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Apologies for the sloppiness!
> Postgres version(s)?
x: Aurora PostgreSQL 11.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC)
4.9.3, 64-bit (RDS)
y: PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg19.10+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 9.2.1-9ubuntu2) 9.2.1 20191008, 64-bit (GCP)
>
> Without the actual query and EXPLAIN ANALYZE on it this will be
> difficult to answer with any detail.
>
> Also would be nice to have the table schema.
>
Here's the query, schema and the EXPLAIN ANALYZE
query: https://gist.github.com/mewwts/704663e19a21bc51864f3298f09a18c0
plan: https://explain.depesz.com/s/RQFQ
Best,
--
Mats
CTO @ Dune Analytics
We're hiring: https://careers.duneanalytics.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-11-25 16:57:49 | Re: postgres_fdw insert extremely slow |
| Previous Message | hagen | 2020-11-25 16:43:20 | RE: INSERT Trigger to check for existing records : Does this do what I hope it is doing? |