Most cited

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

Any topic
2016
584

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.

586

Sad Trombone Exoplanet Reality Check

Some people on the internet are getting very excited at the (unconfirmed) reports of an "Earth-like" exoplanet orbiting Proxima Centauri , a mere 4.25 light-years away from Earth. If correct, the planet is orbiting in the liquid water zone around our nearest stellar neighbour and is of the same order of mass as the…