Logical Replication and Avito
summary
Avito uses PostgreSQL logical replication to handle growing data volume and query load. The talk describes using logical replication for scaling and load distribution, delivering data to the data warehouse and search systems, and synchronizing data between databases and services.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 3:16Logical replication history
- 14:41How logical replication works
- 21:23Physical to logical replication
- 31:24Streaming replication architecture
- 35:17Logical replication usage patterns
- 47:24Live demonstration
- 1:43:33Implementation issues and solutions
- 1:47:58Q&A
related talks
31mImplementing Disaster Recovery
51mEvolution of the PostgreSQL Storage for Listings at Avito
53mThe journey towards active replication in PostgreSQL
59mLogical Replication...LIVE!
31mPast, Present, and Future: Logical Decoding and Replication in PostgreSQL
42mlesser known Superpower of Postgres Logical Replication
44mThe journey towards active-active replication in PostgreSQL
48mChoosing a Replication System for PostgreSQL