On Wed, May 18, 2016 at 6:00 AM, Manuel Kniep <[email protected]> wrote: > 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 ?
Using a single query string with multiple values, perhaps, but after that comes into consideration query string limit particularly for large text values... The query used for the insertion is a prepared statement since writable queries are supported in 9.3, which makes the code quite simple actually. > Are there any plans doing that or am I miss something? Not that I know of. I am adding Fujita-san in the loop here, he is quite involved with postgres_fdw these days so perhaps he has some input to offer. -- Michael -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
