Скачать или смотреть Scaling Postgres Episode 231 The Public Schema, Kubernetes Experience, Dump Manifest, PgBouncer Fork

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

In this episode of Scaling Postgres, we discuss the PG15 changes to public schema permissions, experiences with kubernetes for Postgres management, using dump manifests for restores and a fork of PgBouncer.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:28 - Changes to the public schema in PostgreSQL 15 and how to handle upgrades
02:43 - PostgreSQL On Kubernetes Experiences
04:28 - 5mins of Postgres E33: Postgres on Kubernetes, choosing the right operator, and handling major version upgrades
05:02 - Working With PostgreSQL Dump Manifests
06:22 - Open sourcing our fork of PgBouncer
08:07 - How PostgreSQL 15 improved communication in logical replication
10:24 - SQL/JSON is postponed
11:01 - PostgreSQL: ALTER TABLE … ADD COLUMN … done right
12:56 - Postgres Migration Pitstop: Collations
15:42 - Timescale Cloud Tips: Migrate Your PostgreSQL Production Database - Without Downtime
16:57 - Fill Gaps in Statistical Time Series Results
17:46 - Intro to query optimization
18:00 - Douglas Hunley
18:10 - Rubber Duck Dev Show Episode 57 | Going Off The Rails With Drew Bragg
18:38 - Outro

#postgres #postgresql