I worked many years at 2ndQuadrant; in 2020 it was acquired by EDB, where I now work as the Vice President of Solutions Architecture, leading a team who helps our customers implement Bi-Directional Replication (BDR) for PostgreSQL. Before that, I worked at the University of Florence as a researcher in Mathematics, using Free Software since 1997. I have been a board member of the Italian PostgreSQL User Group (ITPUG); I helped organising the first European PGDay in Prato, Italy (2008) and many editions of the the Italian PGDay. I am an author of several editions of the PostgreSQL Administration Cookbook.
In this talk we describe the history of Logical Replication for PostgreSQL, with a focus on the features that were gradually introduced in each release. We will also compare it against Physical Replication, discussing replication performance, resource usage and appropriate use cases.