Postgres 16
Nikolay and Michael discuss the release of PostgreSQL 16 — the most important new features, what they mean for us as users, whether and when to upgrade, and more.
Here are some links to some extra things they mentioned:
Here are some links to some extra things they mentioned:
- Release notes https://www.postgresql.org/docs/current/release-16.html
- New Features With Examples (PDF from Noriyoshi Shinoda of Hewlett Packard Enterprise Japan) https://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL16Beta1_New_Features_en_20230528_1.pdf
- Why Upgrade? (site by depesz) https://why-upgrade.depesz.com/
- Waiting for PostgreSQL 16 (blog post series from Depesz) https://www.depesz.com/tag/pg16/
- Our episode on favourite features https://postgres.fm/episodes/our-favourite-v16-feature
- Our episode on logical replication https://postgres.fm/episodes/logical-replication
- Active Active in Postgres 16 (blog post from Crunchy Data) https://www.crunchydata.com/blog/active-active-postgres-16
- AlloyDB adaptive autovacuum https://cloud.google.com/blog/products/databases/alloydb-for-postgresql-under-the-hood-adaptive-autovacuum
- Visualizing Postgres I/O Performance (talk by Melanie Plageman at PGCon) https://www.youtube.com/watch?v=CxyPZHG5beI
- Our monitoring checklist episode https://postgres.fm/episodes/monitoring-checklist
- pgvector https://github.com/pgvector/pgvector
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork