Remove redundant DISTINCT when GROUP BY already guarantees uniqueness

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 9, First patch: +2080−50, All patches: +2504−50

Tags

Performance

Created

2026-06-09 12:30:15

Last modified

2026-07-23 20:40:21 (3 months ago)

Latest email

2026-07-23 20:39:44 (3 months ago)

Status

PG20-1 (2026-07-01 – 2026-07-31): Withdrawn

Target version

stable

Authors

Ilia Evdokimov (ilidock95)

Reviewers

Andrés Taylor (systay) Log in to 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-07-23 20:39:44 by Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Latest attachment (v2-0009-Populate-uniquekeys-for-GROUP-BY-so-it-can-make-D.patch) at 2026-07-23 14:44:06 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Attachment (v2-0009-Populate-uniquekeys-for-GROUP-BY-so-it-can-make-D.patch) at 2026-07-23 14:44:06 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: No)
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-07-23 20:40:21	Ilia Evdokimov (ilidock95)	Closed in commitfest PG20-1 with status: Withdrawn
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