New

The latest blog posts to take off on Hacker News. 4,224 posts.

Databases & Data
Any year
2663

Postgres indexes under the hood

Many software engineers use database indexes every day, but few of us really understand how they work. In this post I’ll explain: How indexing works in Postgres using B-Trees What B-Trees are Why they are a good fit for this problem Indexes in Postgres Postgres actually offers 4 different kinds of indexes for…