Re: foreign table batch inserts

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: foreign table batch inserts
Дата
Msg-id CAMsr+YHBenGv-qNMRSdBJ+skV+868edHum1TEv+n72ywyNz67w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: foreign table batch inserts  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
Ответы Re: foreign table batch inserts  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
Список pgsql-hackers
On 19 May 2016 at 14:08, Tsunakawa, Takayuki <tsunakawa.takay@jp.fujitsu.com> wrote:
 

 

Yes, I want FE-BE protocol-level batch inserts/updates/deletes, too.  I was just about to start thinking of how to implement it because of recent user question in pgsql-odbc.  The OP uses Microsoft SQL Server Integration Service (SSIS) to migrate data to PostgreSQL.  He asked for a method to speed up multi-row inserts, because the ODBC's multi-row insert API takes as long a time as when performing single-row inserts separately.  This may prevent the migration to PostgreSQL.


Well, there's FE/BE level batching/pipelining already. Just no access to it from libpq.
 


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Declarative partitioning
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: Autovacuum to prevent wraparound tries to consume xid