Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

Поиск
Список
Период
Сортировка
Искать
От
Laurenz Albe
Тема
Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper
Дата
Msg-id
9622edaf5d266501be4090937baa11a2b887cbe1.camel@cybertec.at
Ответ на
Список
Дерево обсуждения
Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Niels Jespersen <NJN@dst.dk>
Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Laurenz Albe <laurenz.albe@cybertec.at>
SV: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Niels Jespersen <NJN@dst.dk>
Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Magnus Hagander <magnus@hagander.net>
Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Laurenz Albe <laurenz.albe@cybertec.at>
Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Mladen Gogala <gogala.mladen@gmail.com>
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 по дате отправления
От: Tim Uckun
Дата:
От: Laurenz Albe
Дата:
FAQ