Top posts

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

Systems & Performance
2022
47

Win32 Is the Only Stable ABI on Linux?

In the ELF format there are two ways of providing a hash table of symbols. DT_HASH and DT_GNU_HASH . The first one is part of SYSV generic ABI and is well documented and marked as mandatory. DT_GNU_HASH is a newer, smaller, and faster replacement that is not documented , implemented in a few places (Glibc, GNU ld…

55

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…