Description

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:

• 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