JSON in PostgreSQL - evil data type or just needs to be tamed? | POSETTE: An Event for Postgres 2026

Microsoft Developer
AI summary

This talk explores common pitfalls when using JSON/JSONB in PostgreSQL, covering index strategies, TOAST table implications, and performance optimization techniques. Designed for developers and DBAs who already use JSON columns and want to avoid common mistakes like unused indexes and unpredictable query performance. Includes real-world case studies for taming JSONB data.