Most cited

Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 344 posts.

Any topic
2016
242

Postgres Count Performance

Everybody counts, but not always quickly. This post looks into how the PostgreSQL database optimizes counting. In Postgres, there are ways to count orders of magnitude faster. We’ll look at exact counts (distinct counts) as well as estimated counts, using approximation algorithms such as HyperLogLog (HLL) in Postgres.

262

YC Changes

TL;DR: *Michael Seibel will be the new CEO of YC Core, which we are now just going to call “YC”. *Ali Rowghani is now the CEO of the YC Continuity Fund. *I’m going to be the President of YC Group, which includes YC, YC Continuity, YC Research, and our new online class. We’ll add more organizational units over time…