A hands-on guide to PostgreSQL indexes for web developers: B-tree, composite, partial, expression, and GIN/trigram indexes, plus how to read EXPLAIN ANALYZE to actually measure wins.
