Postgres Pro
Downloads
Home   >   mailing lists

Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper
Date
Msg-id 9622edaf5d266501be4090937baa11a2b887cbe1.camel@cybertec.at
Whole thread Raw
In response to Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
Tree view 
On Mon, 2021-09-20 at 15:41 +0200, Magnus Hagander wrote:
> Just as a note, with PostgreSQL 14 the FDW APIs allow batch insert. It
> should be possible to update oracle_fdw to take advantage of that as
> well, right?

Yes.  The exercise is more complicated in Oracle, because they don't
support multi-line INSERTs.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Re: Timestamp with vs without time zone.
Next
From: Laurenz Albe
Date:
Subject: Re: Timestamp with vs without time zone.