Reduce memory used by partitionwise joins Specifically, this commit reduces the memory consumed by the SpecialJoinInfos that are allocated for child joins in try_partitionwise_join() by freeing them at the end of creating paths for each child join.
A SpecialJoinInfo allocated for a given child join is a copy of the parent join's SpecialJoinInfo, which contains the translated copies of the various Relids bitmapsets and semi_rhs_exprs, which is a List of Nodes. The newly added freeing step frees the struct itself and the various bitmapsets, but not semi_rhs_exprs, because there's no handy function to free the memory of Node trees. Author: Ashutosh Bapat <ashutosh.bapat....@gmail.com> Reviewed-by: Richard Guo <guofengli...@gmail.com> Reviewed-by: Amit Langote <amitlangot...@gmail.com> Reviewed-by: Andrey Lepikhov <a.lepik...@postgrespro.ru> Reviewed-by: Tomas Vondra <tomas.von...@enterprisedb.com> Discussion: https://postgr.es/m/caexhw5thqef3asvqvffcghygpfpy7o3xnvhhwbgbjfmrh8k...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/5278d0a2e870c61f9374a7796b90e6f9f6a73638 Modified Files -------------- src/backend/optimizer/path/joinrels.c | 36 +++++++++++++++++++++++++++++++++++ src/backend/optimizer/util/pathnode.c | 5 +++-- src/include/nodes/pathnodes.h | 3 +++ 3 files changed, 42 insertions(+), 2 deletions(-)