Hello,
Modified the patch as I talked with Tomas-san. The performance results of
loading one million records into a hash-partitioned table with 8 partitions are
as follows:
unpatched, local: 8.6 seconds
unpatched, fdw: 113.7 seconds
patched, fdw: 12.5 seconds (9x improvement)
The test scripts are also attached. Run prepare.sql once to set up tables and
source data. Run local_part.sql and fdw_part.sql to load source data into a
partitioned table with local partitions and a partitioned table with foreign
tables respectively.
Regards
Takayuki Tsunakawa
fdw.sql
Description: fdw.sql
fdw_part.sql
Description: fdw_part.sql
local.sql
Description: local.sql
local_part.sql
Description: local_part.sql
prepare.sql
Description: prepare.sql
v2-0001-Add-bulk-insert-for-foreign-tables.patch
Description: v2-0001-Add-bulk-insert-for-foreign-tables.patch
