Scaling Postgres Episode 241 PG 15.1, PG 10 Retrospective, Reducing Replication Lag, Listen & Notify

To get the show notes as well as get notified of new episodes, visit:

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.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:29 - PostgreSQL 15.1, 14.6, 13.9, 12.13, 11.18, and 10.23 Released!
01:10 - A tribute to PostgreSQL 10
02:57 - Postgres v15 - a billion transactions later
03:54 - Reducing replication lag with IO concurrency in Postgres 15
07:40 - Listening to Postgres: How LISTEN and NOTIFY Syntax Promote High Availability at the Application Layer
09:37 - Logical Replication Improvements in PostgreSQL-15
11:10 - 5mins of Postgres E43: Logical replication in Postgres 15 & why the REPLICA IDENTITY matters
11:41 - Performance impact of row filters and column lists in logical replication
12:55 - Read Before You Upgrade: Best Practices for Choosing Your PostgreSQL Version
14:41 - Rewrite OR to UNION in PostgreSQL queries
15:35 - Using PostgreSQL® JSON functions to navigate reviews of restaurants in India
16:14 - Securing Patroni REST API End Points Part 2: Using SSL Certificates
16:38 - Database branching
16:58 - Wilfried Roset
17:08 - Rubber Duck Dev Show Episode 65 | Callbacks: Good or Evil?
17:28 - Outro

#postgres #postgresql

[mikejakubik]

For the lag replication reduction work, FreeBSD at least supports POSIX_FADV_WILLNEED, though I don't know if that applies to just UFS or ZFS as well.

[rosendo]

video cover says 214 :) instead of 241