JSON in PostgreSQL - evil data type or just needs to be tamed? | POSETTE: An Event for Postgres 2026
Postgresql Json Jsonb Database optimization Schema design Indexing Toast tables Postgresql performance Edb Posette
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.