Hi Andrey,
I had a general look at this extension feature, I think it's beneficial for some application scenarios of PostgreSQL.
SoI did 7 performance cases test on your patch(v13). The results are really good. As you can see below we can get 7-10
timesimprovement with this patch.
PSA test_copy_from.sql shows my test cases detail(I didn't attach my data file since it's too big).
Below are the test results:
'Test No' corresponds to the number(0 1...6) in attached test_copy_from.sql.
%reg=(Patched-Unpatched)/Unpatched), Unit is millisecond.
|Test No| Test Case |Patched(ms) |
Unpatched(ms)|%reg |
|-------|-----------------------------------------------------------------------------------------|-------------|---------------|-------|
|0 |COPY FROM insertion into the partitioned table(parition is foreign table) | 102483.223 |
1083300.907 | -91% |
|1 |COPY FROM insertion into the partitioned table(parition is foreign partition) | 104779.893 |
1207320.287 | -91% |
|2 |COPY FROM insertion into the foreign table(without partition) | 100268.730 |
1077309.158 | -91% |
|3 |COPY FROM insertion into the partitioned table(part of foreign partitions) | 104110.620 |
1134781.855 | -91% |
|4 |COPY FROM insertion into the partitioned table with constraint(part of foreign partition)| 136356.201 |
1238539.603 | -89% |
|5 |COPY FROM insertion into the foreign table with constraint(without partition) | 136818.262 |
1189921.742 | -89% |
|6 |\copy insertion into the partitioned table with constraint. | 140368.072 |
1242689.924 | -89% |
If there is any question on my tests, please feel free to ask.
Best Regard,
Tang