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 mult
On Mon, Sep 20, 2021 at 3:18 PM Laurenz Albe wrote:
>
> On Sun, 2021-09-19 at 10:28 +, Niels Jespersen wrote:
> > We are often using the oracle_fdw to transfer data between Postgres
> > (version 11+) and Oracle (version 18+). It works great.
> >
> > However I have a task at hand that requires
On Sun, 2021-09-19 at 10:28 +, Niels Jespersen wrote:
> We are often using the oracle_fdw to transfer data between Postgres (version
> 11+) and Oracle (version 18+). It works great.
>
> However I have a task at hand that requires inserting a few billion rows in
> an Oracle table from a Post
On 9/19/21 06:28, Niels Jespersen wrote:
Hello all
We are often using the oracle_fdw to transfer data between Postgres
(version 11+) and Oracle (version 18+). It works great.
However I have a task at hand that requires inserting a few billion
rows in an Oracle table from a Postgres query.
