Reduce memory used by partitionwise joins
authorAmit Langote <amitlan@postgresql.org>
Mon, 25 Mar 2024 03:02:40 +0000 (12:02 +0900)
committerAmit Langote <amitlan@postgresql.org>
Mon, 25 Mar 2024 09:06:46 +0000 (18:06 +0900)
commit5278d0a2e870c61f9374a7796b90e6f9f6a73638
tree065299c04b8ad160394bf832a33dcfe53d226617
parent619bc23a1a2f3750ac3668fe5a7564bc51e01684
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.oss@gmail.com>
Reviewed-by: Richard Guo <guofenglinux@gmail.com>
Reviewed-by: Amit Langote <amitlangote09@gmail.com>
Reviewed-by: Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Reviewed-by: Tomas Vondra <tomas.vondra@enterprisedb.com>
Discussion: https://postgr.es/m/CAExHW5tHqEf3ASVqvFFcghYGPfpy7o3xnvhHwBGbJFMRH8KjNw@mail.gmail.com
src/backend/optimizer/path/joinrels.c
src/backend/optimizer/util/pathnode.c
src/include/nodes/pathnodes.h