Blogs / Personal blogs

Russell Cohen

rcoh.me

Russell Cohen's Blog and Website

Popular posts
6
Total points
1,462
HN comments
751
Rank
#1,294 personal

Visit rcoh.me → RSS feedOn Hacker News Jan 2018 – Jul 2024

Software Engineering 6Math & Algorithms 2Programming Languages 2Systems & Performance 1Databases & Data 1

1

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…