Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Niels Jespersen <NJN(at)dst(dot)dk>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper
Date: 2021-09-21 07:35:47
Message-ID: 9622edaf5d266501be4090937baa11a2b887cbe1.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2021-09-21 07:39:34 Re: Timestamp with vs without time zone.
Previous Message Tim Uckun 2021-09-21 07:35:20 Re: Timestamp with vs without time zone.