Scaling PostgreSQL Replicas Under Load
summary
Techniques and practical tweaks to speed up PostgreSQL backups, presented with focus on cloud-deployed clusters. Covers WAL-G-based backup mechanisms, approaches for high availability, data durability and confidentiality, cost reduction, throughput maximization, and operational transparency for replicated PostgreSQL under load.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 1:09High availability in PostgreSQL
- 2:38Adding replicas scenarios
- 7:23Wal-G presentation
- 16:15Wal Delta technology
- 26:31Wal Delta in practice
- 28:54Wal-G in Yandex Cloud
- 29:56Q&A
related talks
42mPostgreSQL Distributed: Architectures & Best practices
48mPostgreSQL Replication: 20 Pitfalls and Solutions
36mDesigning Layered High‑Availability Architectures for PostgreSQL on a Budget
56mPostgreSQL Backup Strategies
10mBackups Are Good, Replicas Are Better: Demystifying Replication on PostgreSQL
22mSecuring Postgres with streaming replication
22mPostgreSQL Disaster Recovery Fundamentals
55mHigh Availability with PostgreSQL and Pacemaker