Conference Schedule - PGConf.DE 2022

Benchmarking four Different Replication Solutions

Date: 2022-05-13
Time: 11:20–12:05
Room: South Dakota
Level: Intermediate
Feedback: Leave feedback

Have you ever wondered why there are no benchmarks comparing different replication solutions? I did too, so I wrote my master's thesis on it to finally compare all the apples and oranges that are available for comparison. Actually, I "only" picked in-core streaming, in-core logical, pglogical, and Postgres Pro's multimaster. I learned a great deal along the way and there are surely a lot of things that you can learn here as well, not only about the performance, but also about other replication related issues. The talk will primarily discuss the benchmark setup, results, my interpretation of the results. I'll also explain some issues that I discovered while blasting benchmarks at unsuspecting clusters and the bottlenecks that where brought to light, and some approaches to hide these bottlenecks. Finally, this may hopefully spark some discussions on the numbers achieved, enlighten me why those bottlenecks that where discovered exist, or how they might be fixed.

keywords: replication, streaming, logical, pglogical, multimaster, postgres, postgresql, benchmark, lag

Slides

The following slides have been made available for this session:

Speaker

Julian Markwort