RE: POC: postgres_fdw insert batching

Поиск
Список
Период
Сортировка
От tsunakawa.takay@fujitsu.com
Тема RE: POC: postgres_fdw insert batching
Дата
Msg-id TYAPR01MB2990FC82356124F692545B53FEFA0@TYAPR01MB2990.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: POC: postgres_fdw insert batching  (Craig Ringer <craig.ringer@enterprisedb.com>)
Ответы Re: POC: postgres_fdw insert batching
Список pgsql-hackers
From: Craig Ringer <craig.ringer@enterprisedb.com> 
> I suggest that when developing this, you keep in mind the ongoing work on the libpq pipelining/batching enhancements,
andalso the way many interfaces to foreign data sources support asynchronous, concurrent operations.
 

Yes, thank you, I bear it in mind.  I understand it's a feature for batching multiple kinds of SQL statements like
DBC'sbatch updates.
 


> I'd argue it's pretty much vital for decent performance when talking to a cloud database from an on-prem server for
example,or any other time that round-trip-time reduction is important.
 

Yeah, I'm thinking of the data migration and integration as the prominent use case.


Regards
Takayuki Tsunakawa


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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [Proposal] Global temporary tables
Следующее
От: Seino Yuki
Дата:
Сообщение: Re: [PATCH] Add features to pg_stat_statements