Top posts

Every blog post that took off on Hacker News, ranked by the votes of its best submission. 6,943 posts.

Systems & Performance
Any year
587

Postgres 15 improves UNIQUE and NULL

Postgres 15 beta 2 was released recently! I enjoy Beta season... reviewing and testing new features is a fun diversion from daily tasks. This post takes a look at an improvement to UNIQUE constraints on columns with NULL values . While the nuances of unique constraints are not as flashy as making sorts faster (that's…