Why Database Indexing on JSON Fields Fails in Production
from Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations Hosted by Fexingo
Episode 64 of Database Tech with Fexingo dives into a trap that catches even senior engineers: indexing JSON fields in PostgreSQL and MySQL. Lucas and Luna dissect a real incident from a mid-size e-commerce company whose product search slowed to a crawl after they indexed a JSONB column with a GIN index. They explain why JSON indexes look great on paper but explode in size and cost under write-heavy workloads — and how the team fixed it with a generated column index instead. Expect concrete numbers: the index was 8x larger than equivalent columns, and query latency jumped from 12 milliseconds to over 2 seconds during peak traffic. If you're storing JSON in a relational database, this episode will save you from a painful Monday morning. #JSONIndexing #PostgreSQL #MySQL #GINIndex #GeneratedColumn #DatabasePerformance #IndexBloat #DatabaseEngineering #QueryOptimization #Ecommerce #ProductionIncident #DatabaseTuning #Technology #DatabaseTech #FexingoBusiness #BusinessPodcast #SQL #NoSQL Keep every episode free: buymeacoffee.com/fexingo
Embed this episode
No transcript yet.