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
-Oprindelig meddelelse-
>Fra: Laurenz Albe
>Sendt: 20. september 2021 15:18
>Til: Niels Jespersen ; pgsql-gene...@postgresql.org
>Emne: Re: Possibilities for optimizing inserts across oracle_fdw foreign data
>wrapper
>
>On Sun, 2021-09-19 at 10:28 +, Niels J
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
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
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.
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.
insert into t_ora (a,b,c)
select a,b,c from