Commit15fcd33

Etsuro Fujita

committed

Doc: Update documentation for asynchronous execution.

Add a note of caution on the performance of asynchronous execution bypostgres_fdw. Follow-up for commit27e1f14.Stephen Frost, a little bit expanded by me.Discussion:https://postgr.es/m/20210506171224.GV20766%40tamriel.snowman.net

1 parent07af57d commit15fcd33Copy full SHA for 15fcd33

File tree

+10

-0

lines changed

+10

-0

lines changed

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -401,6 +401,16 @@ OPTIONS (ADD password_required 'false');`
`401`	`401`	`A table-level option overrides a server-level option.`
`402`	`402`	`The default is <literal>false</literal>.`
`403`	`403`	`</para>`
	`404`	`+`
	`405`	`+ <para>`
	`406`	`+ In order to ensure that the data being returned from a foreign server`
	`407`	`+ is consistent, <filename>postgres_fdw</filename> will only open one`
	`408`	`+ connection for a given foreign server and will run all queries against`
	`409`	`+ that server sequentially even if there are multiple foreign tables`
	`410`	`+ involved, unless those tables are subject to different user mappings.`
	`411`	`+ In such a case, it may be more performant to disable this option to`
	`412`	`+ eliminate the overhead associated with running queries asynchronously.`
	`413`	`+ </para>`
`404`	`414`	`</listitem>`
`405`	`415`	`</varlistentry>`
`406`	`416`

Comments

(0)