PostgreSQL Replication Conflicts: Avoiding Pitfalls

This session was presented on Percona Community Live Online June 21-23, 2022. Check out the full schedule here.

Experiencing replication conflicts is not too unfamiliar a sight. Whether one experiences replication lag, slots, locks, snapshots, tablespace issues, or other conflicts, establishing a set of best practices along with using proper observability tools will help avoid potential issues. This talk focuses on what to do and what not to in order to avoid database conflicts in streaming replication setups by providing deep insight into how issues are PostgreSQL internals.

Watch Video Here

Link: https://youtu.be/RmuTMRkgbDY

Transcript

Speakers

Hamid Akhtar

Senior Software Engineer, Percona

See all talks by Hamid Akhtar »

Did you like this post? Why not read more?

Percona Community Live June 21 - Day 1

You are invited to participate in the first day of the Percona Community Live stream! Learn about VictoriaMetrics, flexible Indexing with Postgres, PostgreSQL backups, database resiliency, and many other things on June 21st. Join us on June 22nd and June 23d for more amazing content!

Data Gravity Episode 3 - benny Vasquez - AlmaLinux Project and the Future of Databases

In this episode, Joe Brockmeier interviews benny Vasquez of the AlmaLinux Project to discuss open source data, the future of databases, and how databases and Linux distros go together.

Data Gravity Episode 2 - Sonia Valeja and David Gonzalez - PostgreSQL for Jobseekers Book

In this episode, Joe Brockmeier talks to Percona’s Sonia Valeja and David Gonzalez, about their recent book PostgreSQL for Jobseekers. They talk about the inspiration for the book, why they focus on jobseekers, and what’s covered in the title.