postgres.git / summary / log / commit / refs

commit    0f0a7183d7d8632a2bbcdad796580b4cc541c639
Author:   Etsuro Fujita <efujita@postgresql.org>
Date:     Fri Mar 24 03:55:00 2023 +0000
First released in: 16.0

    Doc: Improve description of the "batch_size" option for postgres_fdw.
    
    Document that the actual number of rows postgres_fdw inserts at once in
    the COPY case is determined in a similar way to the INSERT case, but it
    has a restriction that does not apply to the INSERT case.
    
    Follow-up for commit 97da48246.
    
    Reviewed-by: Daniel Gustafsson and Tatsuo Ishii
    Discussion: https://postgr.es/m/CAPmGK14NMXDMW4qK9kHUzudN9t71uvrMKPna02X6zwgQJ6E1_g%40mail.gmail.com


 doc/src/sgml/postgres-fdw.sgml | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml
index 372236ec13c..d43ea71407f 100644
--- a/doc/src/sgml/postgres-fdw.sgml
+++ b/doc/src/sgml/postgres-fdw.sgml
@@ -437,7 +437,11 @@ OPTIONS (ADD password_required 'false');
       </para>
 
       <para>
-       This option also applies when copying into foreign tables.
+       This option also applies when copying into foreign tables.  In that case
+       the actual number of rows <filename>postgres_fdw</filename> copies at
+       once is determined in a similar way to the insert case, but it is
+       limited to at most 1000 due to implementation restrictions of the
+       <command>COPY</command> command.
       </para>
      </listitem>
     </varlistentry>


[parent: bcaa1fafc82f]