Re: Archiving Data to Another DB? - Mailing list pgsql-general

From Don Seiler
Subject Re: Archiving Data to Another DB?
Date
Msg-id CAHJZqBDCoWa5Hj9Ue282_tgW1YR+2AP7enfJhH99CRJD29h-sw@mail.gmail.com
Whole thread Raw
In response to Re: Archiving Data to Another DB?  (Don Seiler <don@seiler.us>)
List pgsql-general
On Wed, Apr 11, 2018 at 1:13 PM, Don Seiler <don@seiler.us> wrote:

I had considered this as well, as this would allow me to rollback the delete (assuming my intel on postgres_fdw transactions was correct, which it may not be after all). I wondered if a remote insert would be broken up into individual inserts like the remote delete was, as that would be equally unappealing for the same reasons. But obviously worth confirming.

I have now confirmed that a remote INSERT does get broken up into a single INSERT for each row.

--
Don Seiler
www.seiler.us

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Archiving Data to Another DB?
Next
From: Don Seiler
Date:
Subject: Re: Archiving Data to Another DB?