Hello,
Modified the patch as I talked with Tomas-san. The performance results of loading one million records into a
hash-partitionedtable 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.sqlto load source data into a partitioned table with local partitions and a partitioned table with foreign
tablesrespectively.
Regards
Takayuki Tsunakawa