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
|
| Список | 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.
В списке pgsql-hackers по дате отправления: