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

From Antonin Houska
Subject Re: Remove redundant DISTINCT when GROUP BY already guarantees uniqueness
Date
Msg-id 39973.1784820213@localhost
Whole thread
In response to Remove redundant DISTINCT when GROUP BY already guarantees uniqueness  (Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>)
Responses Re: Remove redundant DISTINCT when GROUP BY already guarantees uniqueness
List pgsql-hackers
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

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".

--
Antonin Houska
Web: https://www.cybertec-postgresql.com



pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: BUG: ReadStream look-ahead exhausts local buffers when effective_io_concurrency>=64
Next
From: Masahiko Sawada
Date:
Subject: Re: Fix race condition in pg_get_publication_tables with concurrent DROP TABLE