Top posts

Every blog post that took off on Hacker News, ranked by the votes of its best submission. 2,240 posts.

Any topic
2026
814

Introduction to PostgreSQL Indexes

Who’s this for Basics How data is stored in disk How indexes speedup access to data Costs associated with indexes Disk Space Write operations Query planner Memory usage Types of Indexes Btree Hash BRIN GIN GiST & SP-GiST Conclusion Who’s this for This text is for developers that have an intuitive knowledge of what…