Postgres FM
JSON
Feb 24, 2023
Nikolay and Michael discuss JSON, options for storing it in Postgres, JSON functions available, JSONB indexing, popularity and advantages of PostgreSQL, configuring toast value threshold in Postgres, and performance penalties for medium-sized data.
31:59
AI Summary
AI Chapters
Episode notes
Podcast summary created with Snipd AI
Quick takeaways
- JSON B is the recommended choice for storing JSON in Postgres due to its binary format, indexing support, and more efficient storage.
- Careful consideration should be given to the use case and individual requirements when using JSON in Postgres, as it can lead to challenges in joining columns, lack of statistics, and potential data quality issues.
Deep dives
Storing JSON in Postgres and the options available
The podcast episode discusses the different options for storing JSON in Postgres, including arrays, H store, and JSON B. Arrays have been supported in Postgres for a long time and can store various types of data. H store, which is a key-value format, appeared in 2004 and provides flexibility. However, both arrays and H store break the first normal form. JSON B, implemented in 2014, is the recommended choice due to its binary format, indexing support, and more efficient storage.
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
