Scaling Postgres Episode 185 Postgres 14 Released | Using JSON | Not Using Indexes | Sequence Gaps

In this episode of Scaling Postgres, we discuss the release of Postgres 14, how best to use JSON, why are your indexes not being used and sequence gaps.

Content Discussed

• PostgreSQL 14 Released!
• How We Shipped PostgreSQL 14 on Azure Within One Day of its Release
• PostgreSQL 14: PostgreSQL Is Still a Tweeny
• Upgrading PostgreSQL 9.6 to PostgreSQL 13
• JSON in PostgreSQL: how to use it right
• Using recursive queries to get distinct elements from table
• Why isn’t Postgres using my index?
• Zero-downtime Postgres schema migrations need this: lock_timeout and retries
• Gaps in sequences in PostgreSQL
• 3 ways to auto-increment with Postgres
• Devious SQL: Dynamic DDL in PostgreSQL
• PostgreSQL 14 Continuous archiving and Point In Time Recovery
• PostgreSQL vs Python for data evaluation: what, why, and how
• Boost query performance using Foreign Data Wrapper with minimal changes
• Jeff Davis
• Rubber Duck Dev Show Episode 15 | When To Use UUIDs

YouTube Video