I'm resending this because I failed to reply to all. On Sat, May 8, 2021 at 12:55 AM Etsuro Fujita <etsuro.fuj...@gmail.com> wrote: > On Fri, May 7, 2021 at 2:12 AM Stephen Frost <sfr...@snowman.net> wrote: > > In order to ensure that the data being returned from a foreign server > > is consistent, postgres_fdw will only open one connection for a given > > foreign server and will run all queries against that server sequentially > > even if there are multiple foreign tables involved. In such a case, it > > may be more performant to disable this option to eliminate the overhead > > associated with running queries asynchronously. > > Ok, I’ll merge this into the next version.
Stephen’s version would be much better than mine, so I updated the patch as proposed except the first sentence. If the foreign tables are subject to different user mappings, multiple connections will be opened, and queries will be performed in parallel. So I expanded the sentence a little bit, to avoid misunderstanding. Attached is a new version. Best regards, Etsuro Fujita
note-about-async-v2.patch
Description: Binary data