Scaling Postgres Episode 136 Stat Tracking | Temporary Tables | pg_squeeze | pg_auto_failover

Описание

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

In this episode of Scaling Postgres, we discuss stat tracking, temporary tables, a new utility called pg_squeeze and an update to pg_auto_failover.

Timestamps:

00:00 - Intro
00:27 - Tracking Postgres Stats
03:01 - PostgreSQL: Sophisticating temporary tables
04:04 - pg_squeeze: Optimizing PostgreSQL storage
05:52 - What's new in pg_auto_failover 1.4 for Postgres high availability
07:31 - Multitenancy with Postgres schemas: key concepts explained
09:05 - PostgreSQL Monitoring for App Developers: Alerts & Troubleshooting
10:43 - Tuning Your Postgres Database for High Write Loads
11:36 - Postgres 13 Observability Updates
12:16 - Talking PostGIS on Podcasts
12:32 - Greg Sabino Mullane
12:44 - Outro

#postgres #postgresql