RE: POC: postgres_fdw insert batching - Mailing list pgsql-hackers

From tsunakawa.takay@fujitsu.com
Subject RE: POC: postgres_fdw insert batching
Date
Msg-id TYAPR01MB2990FC82356124F692545B53FEFA0@TYAPR01MB2990.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: POC: postgres_fdw insert batching  (Craig Ringer <craig.ringer@enterprisedb.com>)
Responses Re: POC: postgres_fdw insert batching  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [Proposal] Global temporary tables
Next
From: Seino Yuki
Date:
Subject: Re: [PATCH] Add features to pg_stat_statements