Re: POC: postgres_fdw insert batching

Поиск
Список
Период
Сортировка
Искать
От
Tomas Vondra
Тема
Re: POC: postgres_fdw insert batching
Дата
Msg-id
9808f343-410e-4441-9a10-42e14a1c6436@enterprisedb.com
Ответ на
RE: POC: postgres_fdw insert batching (tsunakawa.takay@fujitsu.com)
Список
Дерево обсуждения
POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: POC: postgres_fdw insert batching "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@2ndquadrant.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@2ndquadrant.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: POC: postgres_fdw insert batching Tim.Colles@ed.ac.uk
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching David Fetter <david@fetter.org>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Tom Lane <tgl@sss.pgh.pa.us>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Ian Lawrence Barwick <barwick@gmail.com>
Re: POC: postgres_fdw insert batching Ian Lawrence Barwick <barwick@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Ian Lawrence Barwick <barwick@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Tom Lane <tgl@sss.pgh.pa.us>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Zhihong Yu <zyu@yugabyte.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Zhihong Yu <zyu@yugabyte.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tom Lane <tgl@sss.pgh.pa.us>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Zhihong Yu <zyu@yugabyte.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Zhihong Yu <zyu@yugabyte.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Zhihong Yu <zyu@yugabyte.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Zhihong Yu <zyu@yugabyte.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Craig Ringer <craig.ringer@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Craig Ringer <craig.ringer@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Craig Ringer <craig.ringer@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Craig Ringer <craig.ringer@enterprisedb.com>
RE: POC: postgres_fdw insert batching "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: POC: postgres_fdw insert batching Craig Ringer <craig.ringer@enterprisedb.com>
Re: POC: postgres_fdw insert batching Andres Freund <andres@anarazel.de>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: POC: postgres_fdw insert batching Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: POC: postgres_fdw insert batching Ashutosh Bapat <ashutosh.bapat@2ndquadrant.com>
Re: POC: postgres_fdw insert batching Etsuro Fujita <etsuro.fujita@gmail.com>
Re: POC: postgres_fdw insert batching Ashutosh Bapat <ashutosh.bapat@2ndquadrant.com>
Re: POC: postgres_fdw insert batching Amit Langote <amitlangote09@gmail.com>
Re: POC: postgres_fdw insert batching Etsuro Fujita <etsuro.fujita@gmail.com>
Hi,

Attached is a v6 of this patch, rebased to current master and with some 
minor improvements (mostly comments and renaming the "end" struct field 
to "values_end" which I think is more descriptive).

The one thing that keeps bugging me is convert_prep_stmt_params - it 
dies the right thing, but the code is somewhat confusing.


AFAICS the discussions about making this use COPY and/or libpq 
pipelining (neither of which is committed yet) ended with the conclusion 
that those changes are somewhat independent, and that it's worth getting 
this committed in the current form. Barring objections, I'll push this 
within the next couple days.


regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления
От: Tatsuro Yamada
Дата:
От: Fujii Masao
Дата:
FAQ