Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning

Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>

From: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>

To: Alvaro Herrera <alvherre@alvh.no-ip.org>

Cc: Dmitry Dolgov <9erthalion6@gmail.com>, tomas@vondra.me, vignesh C <vignesh21@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, Richard Guo <guofenglinux@gmail.com>, David Rowley <dgrowleyml@gmail.com>

Date: 2025-02-04T10:21:20Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add assertion to verify derived clause has constant RHS
- 887160d1beae 18.0 landed
Make derived clause lookup in EquivalenceClass more efficient
- 88f55bc97622 18.0 landed
Doc: improve documentation for jsonpath behavior.
- 7014c9a4bba2 17.0 cited
Work around implementation restriction in adjust_appendrel_attrs.
- 767c598954bb 16.0 cited

On Fri, Jan 31, 2025 at 5:46 PM Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
>
> On 2025-Jan-31, Alvaro Herrera wrote:
>
> > So I tried to rerun Ashutosh's benchmark (of course, on a build
> > with no C assertions, otherwise the numbers are meaningless).  First,
> > the patches still apply to current master.
>
> (BTW I just realized that I applied patches 0001-0004, omitting 0005).

That's ok. The last patch shows a minor regression wrt 0004. It will
be dropped from the patchset anyway.

-- 
Best Wishes,
Ashutosh Bapat