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.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

https://www.postgresql.org/about/news/postgresql-14-released-2318/ https://www.citusdata.com/blog/2021/10/01/how-we-shipped-postgres-14-on-azure-within-a-day/ https://www.instaclustr.com/postgresql-14/ https://www.migops.com/blog/2021/09/29/upgrading-postgresql-9-6-to-postgresql-13/ https://www.cybertec-postgresql.com/en/json-postgresql-how-to-use-it-right/ https://www.depesz.com/2021/09/27/using-recursive-queries-to-get-distinct-elements-from-table/ https://www.pgmustard.com/blog/why-isnt-postgres-using-my-index https://postgres.ai/blog/20210923-zero-downtime-postgres-schema-migrations-lock-timeout-and-retries https://www.cybertec-postgresql.com/en/gaps-in-sequences-postgresql/ https://mydbanotebook.org/post/auto-increment/ https://blog.crunchydata.com/blog/dynamic-ddl-in-postgresql https://www.highgo.ca/2021/10/01/postgresql-14-continuous-archiving-and-point-in-time-recovery/ https://blog.timescale.com/blog/how-to-evaluate-your-data-directly-within-the-database-and-make-your-analysis-more-efficient/ https://www.ongres.com/blog/boost-query-performance-using-fdw-with-minimal-changes/ https://postgresql.life/post/jeff_davis/ https://www.rubberduckdevshow.com/episodes/15-when-to-use-uuids/