AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
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.
Get the Snipd
podcast app
Unlock the knowledge in podcasts with the podcast player of the future.
AI-powered
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode
Save any
moment
Hear something you like? Tap your headphones to save it with AI-generated key takeaways
Share
& Export
Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more
AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode