Re: Archiving Data to Another DB?

On Wed, Apr 11, 2018 at 1:13 PM, Don Seiler <don(at)seiler(dot)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