I realized that inserts into foreign tables are only done row by row.
Consider copying data from one local table to a foreign table with
INSERT INTO foreign_table(a,b,c) SELECT a,b,c FROM local_table;
When the foreign server is for example in another datacenter with long latency,
this as an enormous performance trade off.
Wouldn’t it make sense to do the insert batch wise e.g. 100 rows ?
Are there any plans doing that or am I miss something?
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: