Re: Remove redundant DISTINCT when GROUP BY already guarantees uniqueness - Mailing list pgsql-hackers

On 7/23/26 18:23, Antonin Houska wrote:

Ilia Evdokimov <ilya.evdokimov@tantorlabs.com> wrote:

Thanks a lot for detailed review.

Since there's already patch work on the UniqueKeys approach, I think it make
sense to keep building on that rather than staring over. Thanks for rebase
onto master. I attached 0001-patch with it.

CC: Antonin, Andy

Not sure if you noticed that, related work was posted yesterday:

https://www.postgresql.org/message-id/CAMbWs4-iLcqBr_n_F5gNrzQbBMrKgkpGwqTu7boWeoYepf%3D%2B8g%40mail.gmail.com

Thanks for the information.

I've already spent some time looking at it and I think it's more advanced than
the previous attempts to implement the "unique keys".

So do I. Therefore I'll switch current commitfest into "Withdrawn". I'll take a look Richard's patch too.

-- 
Best regards,
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com/