#Query Optimization

SQL query analysis, index usage, execution plans, and database tuning.

2 Articles

Articles

Database Indexing Strategies: B-Trees, GIN, GiST, and Production Tuning

Backend Engineering

Backend Engineering•Mar 1•9 min read

Database Indexing Strategies: B-Trees, GIN, GiST, and Production Tuning

B-tree internals, composite index ordering, GIN for full-text search, partial indexes, and preventing index bloat in production.

BackendBytes Engineering Team

PostgreSQL Query Planner Internals: From EXPLAIN to Expert Tuning

Backend Engineering

Backend Engineering•Jan 12•9 min read

PostgreSQL Query Planner Internals: From EXPLAIN to Expert Tuning

How PostgreSQL's query optimizer decides, why it gets it wrong, and how to fix it with statistics targets and covering indexes.

BackendBytes Engineering Team