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/