In this episode of Scaling Postgres, we discuss the release of Postgres 15.1, a Postgres 10 retrospective, how to reduce replication lag and using listen & notify.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

• https://www.postgresql.org/about/news/postgresql-151-146-139-1213-1118-and-1023-released-2543/
• https://jkatz05.com/post/postgres/postgres-10-tribute/
• https://kmoppel.github.io/2022-11-09-postgres-v15-a-billion-transactions-later/
• https://www.citusdata.com/blog/2022/11/10/reducing-replication-lag-with-io-concurrency-in-pg15/
• https://www.enterprisedb.com/blog/listening-postgres-how-listen-and-notify-syntax-promote-high-availability-application-layer
• http://amitkapila16.blogspot.com/2022/11/logical-replication-improvements-in.html
• https://pganalyze.com/blog/5mins-postgres-15-logical-replication-replica-identity
• https://www.postgresql.fastware.com/blog/performance-impact-of-row-filters-and-column-lists-in-logical-replication
• https://www.timescale.com/blog/read-before-you-upgrade-best-practices-for-choosing-your-postgresql-version/
• https://www.cybertec-postgresql.com/en/rewrite-or-to-union-in-postgresql-queries/
• https://dev.to/ftisiot/using-postgresqlr-json-functions-to-navigate-reviews-of-restaurants-in-india-39ld
• https://www.percona.com/blog/securing-patroni-rest-api-end-points-part-2-using-ssl-certificates/
• https://postgres.fm/episodes/database-branching
• https://postgresql.life/post/wilfried_roset/
• https://www.rubberduckdevshow.com/episodes/65-callbacks-good-or-evil/