From dc203dc3ac40a4b02b92fb827848a547d2957153 Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Wed, 3 Feb 2016 09:01:59 -0500 Subject: postgres_fdw: Allow fetch_size to be set per-table or per-server. The default fetch size of 100 rows might not be right in every environment, so allow users to configure it. Corey Huinker, reviewed by Kyotaro Horiguchi, Andres Freund, and me. --- doc/src/sgml/postgres-fdw.sgml | 27 ++++++++++++++++++++------- 1 file changed, 20 insertions(+), 7 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml index 5a829d537a6..a90983cb1e9 100644 --- a/doc/src/sgml/postgres-fdw.sgml +++ b/doc/src/sgml/postgres-fdw.sgml @@ -290,17 +290,30 @@ be considered shippable to the remote server. This option can only be specified for foreign servers, not per-table. + + + When using the extensions option, it is the + user's responsibility that the listed extensions exist and behave + identically on both the local and remote servers. Otherwise, remote + queries may fail or behave unexpectedly. + - + + fetch_size + + + This option specifies the number of rows postgres_fdw + should get in each fetch operation. It can be specified for a foreign + table or a foreign server. The option specified on a table overrides + an option specified for the server. + The default is 100. + + + - - When using the extensions option, it is the - user's responsibility that the listed extensions exist and behave - identically on both the local and remote servers. Otherwise, remote - queries may fail or behave unexpectedly. - + -- cgit v1.2.3