Back
Guide
Intermediate
Real Projects

Database Indexing: Designing Indexes and Optimizing Queries in PostgreSQL

Learn to design indexes that genuinely speed up your queries: B-tree, composite, partial, and covering indexes. Includes how to read EXPLAIN ANALYZE, correct column ordering, the mistakes that silently disable an index, and what's new in PostgreSQL 18.

10 minutes read
Josué Puig
0 views

Was this resource helpful?

Share your comments or suggestions to improve our content.

Loading comments...

Related Resources

Guía

Idempotency in APIs: Designing Endpoints That Are Safe to Retry

Learn how idempotency keys turn unreliable networks into predictable APIs, so retries, timeouts, and double-clicks never create a duplicate payment or order. Covers server-side implementation, concurrency handling, what to cache, and common pitfalls.

Tutorial

Tutorial: Microfrontends with React, Vue, and Module Federation

Complete guide to building microfrontend applications using React and Vue with Module Federation, including inter-application communication with RxJS, routing, and best practices.