Re: [PoC] Reducing planning time when tables have many partitions

From: Yuya Watari <watari(dot)yuya(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, jian he <jian(dot)universality(at)gmail(dot)com>, Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>, Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>, David Rowley <dgrowleyml(at)gmail(dot)com>, Thom Brown <thom(at)linux(dot)com>, Zhang Mingli <zmlpostgres(at)gmail(dot)com>
Subject: Re: [PoC] Reducing planning time when tables have many partitions
Date: 2025-02-19 07:33:32
Message-ID: CAJ2pMkaDZxHVxmXf7DOYA6pH-VYY0bR5ojYqv4taEOSGwxHhdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

On Wed, Feb 12, 2025 at 8:29 AM Yuya Watari <watari(dot)yuya(at)gmail(dot)com> wrote:
>
> Compared to previous versions, v31 reduces code size while maintaining
> (or slightly improving) high speedups and low memory consumption. I
> would greatly appreciate any feedback, reviews or further suggestions.

I noticed that the patches did not apply to the current HEAD, so I
have rebased them.

--
Best regards,
Yuya Watari

Attachment Content-Type Size
v32-0001-Speed-up-searches-for-child-EquivalenceMembers.patch application/octet-stream 54.8 KB
v32-0002-Resolve-conflict-with-commit-66c0185.patch application/octet-stream 6.4 KB
v32-0003-Introduce-indexes-for-RestrictInfo.patch application/octet-stream 45.9 KB
v32-0004-Introduce-RestrictInfoIterator-to-reduce-memory-.patch application/octet-stream 17.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2025-02-19 07:35:13 Re: missing assert in makeString
Previous Message Tom Lane 2025-02-19 07:06:51 Re: BUG #18815: Logical replication worker Segmentation fault