Postgres 14 Released, Using JSON, Not Using Indexes, Sequence Gaps | Scaling Postgres 185
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/
Create your
podcast in
minutes
It is Free