Scaling Postgres

Postgres 14 Beta 1, PG 14 Improvements, Best Primary Keys, Composite Keys | Scaling Postgres 166

Informações:

Synopsis

In this episode of Scaling Postgres, we discuss the release of Postgres 14 Beta 1, different PG 14 improvements, choosing the best type of primary key and using composite keys. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/postgresql-14-beta-1-released-2213/ https://pganalyze.com/blog/postgres-14-performance-monitoring https://www.cybertec-postgresql.com/en/uuid-serial-or-identity-columns-for-postgresql-auto-generated-primary-keys/ https://www.endpoint.com/blog/2021/05/20/database-design-using-composite-keys https://www.youtube.com/playlist?list=PLownlFUq_rL6txMapX6UUuquqGdUINmkd https://akorotkov.github.io/blog/2021/05/22/pg-14-query-parsing/ https://blog.crunchydata.com/blog/waiting-for-postgis-3.2-st_interpolateraster https://www.migops.com/blog/2021/05/19/porting-array-length-from-oracle-plsql-to-postgresql-plpgsql/ https://blog.crunchydata.com/blog/pgo-4.7-the-crunchy-postgres-operator-now