Re: Tracking per-RelOptInfo uniqueness during planning

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
Cc: Antonin Houska <ah(at)cybertec(dot)at>, Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andy Fan <zhihuifan1213(at)163(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>
Subject: Re: Tracking per-RelOptInfo uniqueness during planning
Date: 2026-08-25 08:18:37
Message-ID: CAMbWs4-mQ+YwA+J5LtHiZHFhxF5Oyd15wLOEA+d0+XbPj409Hg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Aug 18, 2026 at 9:31 PM Ilia Evdokimov
<ilya(dot)evdokimov(at)tantorlabs(dot)com> wrote:
> planner.c: create_partial_unique_paths()
> ```
> partial_unique_rel->cheapest_parameterized_paths = NIL;
> +partial_unique_rel->uniquekeys = NIL;
>
> /* Estimate number of output rows */
> ```

Thanks. Fixed in v4. v4 also drops the costsize.c changes from 0003,
as the costing issue has been fixed on master.

- Richard

Attachment Content-Type Size
v4-0001-Introduce-UniqueKeys-to-track-the-distinctness-of.patch application/octet-stream 128.5 KB
v4-0002-Teach-UniqueKeys-about-appendrel-children-and-chi.patch application/octet-stream 12.4 KB
v4-0003-Teach-UniqueKeys-about-eager-aggregation-s-groupe.patch application/octet-stream 33.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2026-08-25 08:23:03 Re: Proposal: Conflict log history table for Logical Replication
Previous Message David Rowley 2026-08-25 08:17:33 Re: [PATCH] Avoid signed overflow in bms_prev_member assertion