Re: postgres_fdw batching vs. (re)creating the tuple slots

Tomas Vondra <tomas.vondra@enterprisedb.com>

View thread View on postgr.es

From: Tomas Vondra <tomas.vondra@enterprisedb.com>

To: Tom Lane <tgl@sss.pgh.pa.us>, Andres Freund <andres@anarazel.de>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2021-06-09T10:30:17Z

Lists: pgsql-hackers

Attachments

0001-create-copy-of-a-descriptor-for-batching-v2.patch (text/x-patch)

Hi,

Here's a v2 fixing a silly bug with reusing the same variable in two 
nested loops (worked for simple postgres_fdw cases, but "make check" 
failed).

regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

Fix copying data into slots with FDW batching
- 99cea49d6525 14.0 landed
Optimize creation of slots for FDW bulk inserts
- b676ac443b6a 14.0 landed
Adjust batch size in postgres_fdw to not use too many parameters
- cb92703384e2 14.0 cited