Database Indexing Explained With Real PostgreSQL Examples

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

I ignored database indexing for way too long. My queries worked fine in development with 100 rows. Then production hit a few thousand rows and suddenly everything was slow. A page that loaded in 200ms now took 3 seconds. The fix was almost always the same: add an index. But I also learned that indexes aren’t free. Add too many and your writes slow down. Add the wrong ones and they sit there…

Read on baransel.dev ↗