Horton

Re: Doc: Improve note about copying into postgres_fdw foreign tables in batch

Etsuro Fujita <etsuro.fujita@gmail.com>

View thread View on postgr.es
From: Etsuro Fujita <etsuro.fujita@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Cc: Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Date: 2023-03-22T11:58:40Z
Lists: pgsql-hackers 
On Fri, Feb 17, 2023 at 5:45 PM Etsuro Fujita <etsuro.fujita@gmail.com> wrote:
> Here is a small patch to improve the note, which was added by commit
> 97da48246 ("Allow batch insertion during COPY into a foreign table."),
> by adding an explanation about how the actual number of rows
> postgres_fdw inserts at once is determined in the COPY case, including
> a limitation that does not apply to the INSERT case.

Does anyone want to comment on this?

Best regards,
Etsuro Fujita

Commits

  1. Doc: Improve description of the "batch_size" option for postgres_fdw.

  2. Allow batch insertion during COPY into a foreign table.