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.