Postgres Pro
Downloads
Home   >   mailing lists

Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)' - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)'
Date
Msg-id CAPpHfdsQcGuXfa5sORmftS=V=6P-KoGypVRF=grWLruJaoRtsA@mail.gmail.com
Whole thread Raw
In response to Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)'  (Alexander Korotkov <aekorotkov@gmail.com>)
List pgsql-hackers
Tree view 
On Sun, Dec 24, 2023 at 2:02 PM Alexander Korotkov <aekorotkov@gmail.com> wrote:
> The most noticeable thing for me is that self-join removal doesn't work with partitioned tables.  I think this is the
directionfor future work on this subject.  In non-partitioned cases, patchset gives a small memory overhead.  However,
thememory consumption is still much less than it is without the self-join removal.  So, removing the join still lowers
memoryconsumption even if it copies some Bitmapsets.  Given that patchset [1] is required for the correctness of memory
manipulationsin Bitmapsets during join removals, I'm going to push it if there are no objections. 

Pushed!

------
Regards,
Alexander Korotkov

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Changing references of password encryption to hashing
Next
From: Alexander Korotkov
Date:
Subject: Re: POC: GROUP BY optimization