Topics /

Databases & Data

The most popular blog posts about databases & data on Hacker News. 2,337 posts.

Any year
519

How does a B-tree make queries fast?

B-tree is a structure that helps to search through great amounts of data. It was invented over 40 years ago, yet it is still employed by the majority of modern databases. Although there are newer index structures, like LSM trees, B-tree is unbeaten when handling most of the database queries.

533

CouchDB 3.0

Dear community, Apache CouchDB® 3.0.0 has been released and is available for download. Apache CouchDB® lets you access your data where you need it. The Couch Replication Protocol is implemented in …

539

What's new in the Postgres 16 query planner

Postgres 16 introduces quite a few improvements to the query planner and makes many SQL queries run faster than they did on previous versions of PostgreSQL. This post is a deep dive into 10 of the improvements, including code blocks and comparisons of query plan output between Postgres 15 & Postgres 16.