5mins of Postgres E26: New in Postgres 15 - NULL handling in UNIQUE constraints & Parallel DISTINCT
Today, we are talking about two new features in Postgres 15. First of all, we're going to talk about the new unique constraint NULLS NOT DISTINCT option, and then we'll talk about the SELECT DISTINCT performance improvements.
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
📑 What we have discussed in this episode of 5mins of Postgres:
- Postgres 15 improves UNIQUE and NULL https://blog.rustprooflabs.com/2022/0...
- RustProof Labs on Twitter / rustprooflabs
- PostgreSQL 15 Beta 2 Released https://www.postgresql.org/about/news...
- pgsql-hackers mailing list: UNIQUE null treatment option https://www.postgresql.org/message-id...
- Waiting for PostgreSQL 10 – Identity columns https://www.depesz.com/2017/04/10/wai...
- Discussion about NULLS NOT DISTINCT on Hacker News https://news.ycombinator.com/item?id=...
- Introducing PostgreSQL 15: Working with DISTINCT https://www.percona.com/blog/introduc...
- Percona on Twitter / percona