PostgreSQL Indexing Strategies Beyond the Default B-Tree
When a plain B-tree index is not enough: partial, composite, and trigram indexes, and how to read EXPLAIN ANALYZE to prove it.
By Toshstack Admin — Jun 19, 2026
ToshStack Blog
Practical knowledge formodern developers.
Explore development guides, technical tutorials, practical resources, and insights designed to help you build better products.
New technical articles and resources are published regularly.
PostgreSQL
2 articles
Designing a PostgreSQL Schema with TypeORM That Survives Growth
Practical rules for entities, foreign keys, and migrations in TypeORM so your PostgreSQL schema stays correct as the product grows.
By Toshstack Admin — Mar 11, 2026