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

From pabloa98
Subject Re: postgres_fdw insert extremely slow
Date
Msg-id CAEjudX6v_cAC1GeLWpboOq5KWsBXx-VNP2y4wvp8OuodHE0czg@mail.gmail.com
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  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
I would like to suggest for postgres_fdw: If the foreign database is PostgreSQL, the link should just pass through all the CRUD SQL commands to the other database.

If the other database is of a version so different that cannot make sense of the CRUD SQL command, it will generate an error and that's it.

This would be very useful to keep datasets synchronized.

Pablo

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to debug authentication issues in Postgres
Next
From: "David G. Johnston"
Date:
Subject: Re: postgres_fdw insert extremely slow