The patch in the attachment, compared to the previous one, adds a threshold for using the bloom filter. The current ON_COMMITS_FILTER_THRESHOLD is set to 64, which may not be the optimal value. Perhaps this threshold could be configured as a GUC parameter?
Best Regards, Fei Changhong
v1-0001-Optimize-commit-with-temp-tables.patch
Description: Binary data