POSTGRESQL REPLICATION CONFLICTS: AVOIDING PITFALLS
Hamid has more than two decades of professional software development experience and has been involved with PostgreSQL for more than a decade now. He was part of EnterpriseDB where managed PostgreSQL official installers for Windows, Linux, and macOS. At HighGo Software, he was one of the leading PostgreSQL Architect working on multiple in-house solutions including in-memory solutions, ORC FDW, and various performance features. Hamid is currently the Engineering Lead for PostgreSQL at Percona.
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 an insight into the PostgreSQL internals.
- 2022 April 8 15:20 PDT
- 20 min
- Silicon Valley 2022