Remove redundant DISTINCT when GROUP BY already guarantees uniqueness

Edit
ID 6869
Title Remove redundant DISTINCT when GROUP BY already guarantees uniqueness
CI (CFBot) Summary
Stats (from CFBot) Patch version: v1, Patch count: 1, First patch: +237−1, All patches: +237−1
Tags Performance
Created 2026-06-09 12:30:15
Last modified 2026-06-09 12:30:16 (3 weeks ago)
Latest email 2026-06-22 08:49:01 (1 week ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Waiting on Author
Target version stable
Authors Ilia Evdokimov (ilidock95)
Reviewers Andrés Taylor (systay) Become reviewer
Committer
Links
Emails
Remove redundant DISTINCT when GROUP BY already guarantees uniqueness
First at 2026-06-08 11:12:20 by Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Latest at 2026-06-22 08:49:01 by Andrés Taylor <andres at taylor.se>
Latest attachment (v1-0001-Remove-redundant-DISTINCT-when-GROUP-BY-guarantee.patch) at 2026-06-08 11:12:20 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
    Attachment (v1-0001-Remove-redundant-DISTINCT-when-GROUP-BY-guarantee.patch) at 2026-06-08 11:12:20 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
History
When Who What
2026-06-22 08:49:01 Andrés Taylor (systay) Posted review with messageid <178211814104.991.7333413279255303867.pgcf@coridan.postgresql.org>
2026-06-22 08:49:01 Andrés Taylor (systay) New status: Waiting on Author
2026-06-22 08:25:02 Andrés Taylor (systay) Added systay as reviewer
2026-06-09 12:30:16 Ilia Evdokimov (ilidock95) Attached mail thread faf8f63f-b476-4ca8-89f9-7cfc104b522c@tantorlabs.com
2026-06-09 12:30:15 Ilia Evdokimov (ilidock95) Created patch record
Edit