Postgres 16 is released

*Find the article on our blog here:* https://pganalyze.com/blog/5mins-postgres-16

In E82 of “5mins of Postgres” we're talking about a lot of exciting features in Postgres 16. I give a quick rundown of a few things that I find exciting, as well as a few things that you might have not known about yet that people in the community pointed out in the last couple of weeks.

We had talked about some of them previously in 5mins of Postgres episodes. We will link them at the end of this article!


*Learn more about pganalyze:*
https://pganalyze.com
https://pganalyze.com/newsletter
https://twitter.com/pganalyze/

*Check out the pganalyze library for eBooks, webinars, and more:*
https://pganalyze.com/resources

? *What we have discussed in this episode of 5mins of Postgres:*

*Official Postgres 16 release notes*
https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-HIGHLIGHTS

*PGSQL Phriday #012 Contribution Summary - by Ryan Booz*
https://www.softwareandbooz.com/pgsql-phriday-012-contribution-summary/

*Ryan Booz on Twitter*
https://twitter.com/ryanbooz

*PostgreSQL 16 improves infinity: PgSQLPhriday #012 - by Ryan Lambert*
https://blog.rustprooflabs.com/2023/09/pgsqlphriday-012--postgres16-improves-infinity

*Ryan Lambert on GitHub*
https://github.com/rustprooflabs

*Postgres 16, sysbench and a small server - by Mark Callaghan*
http://smalldatum.blogspot.com/2023/09/postgres-16-sysbench-and-small-server.html

*Mark Callaghan on Twitter*
https://twitter.com/markcallaghandb

*Bi-directional replication using origin filtering in PostgreSQL - by Vigneshwaran C*
https://www.postgresql.fastware.com/blog/bi-directional-replication-using-origin-filtering-in-postgresql

*Vigneshwaran C on postgresql.life Person of the Week*
https://postgresql.life/post/vigneshwaran_c/

*Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io*
https://pganalyze.com/blog/pg-stat-io

*How Postgres DBAs can use pg_stat_io*
https://pganalyze.com/blog/5mins-postgres-16-pg-stat-io-dba

*How bulk loading with COPY can be 300% times faster in Postgres 16 Beta 1*
https://pganalyze.com/blog/5mins-postgres-16-faster-copy-bulk-load

*Waiting for Postgres 16: Logical decoding on standbys*
https://pganalyze.com/blog/5mins-postgres-16-logical-decoding

*Waiting for Postgres 16: Running EXPLAIN on any query (even with $1 parameters!)*
https://pganalyze.com/blog/5mins-postgres-explain-generic-plan

*Waiting for Postgres 16: Buffer cache hit ratio and I/O times in pg_stat_io*
https://pganalyze.com/blog/5mins-postgres-16-buffer-cache-hit-ratio-io-times-pg-stat-io

*Vacuum Cost Limit and Parallel Aggregate improvements in Postgres 16*
https://pganalyze.com/blog/5mins-postgres-16-vacuum-cost-limit-parallel-aggregate

*Postgres 16: Surviving without a superuser & reserved_connections*
https://pganalyze.com/blog/5mins-postgres-16-superuser-reserved-connections

*Using pgbench to load data faster, and the random_normal function in PG16*
https://pganalyze.com/blog/5mins-postgres-16-pgbench-random-normal

*New SQL/JSON and JSON_TABLE features in Postgres 15*
https://pganalyze.com/blog/5mins-postgres-sql-json-table-postgres15

*New in Postgres 15: Logical replication column filters & database-wide ICU collations*
https://pganalyze.com/blog/5mins-postgres-15-logical-replication-filters-database-wide-icu-collations

*Logical replication in Postgres 15 & why the REPLICA IDENTITY matters*
https://pganalyze.com/blog/5mins-postgres-15-logical-replication-replica-identity