← All Talks
View Schedule
Download image
Hanging hundreds of Postgres shutdowns with a simple CDC plugin

Session
Friday, Sep 11
3:45pm – 4:15pm
Matterhorn 3
Whenever any simple switchover needed to be done, it took hours. The customer was killing the primary postmaster out of desperation because it was simply too long. It was reproducing perfectly every time, in every single production and most non-production environments. Was postgres hanging? Was it slow to finish something? Could some application hang a primary shutdown like this?
We will discuss debugging on Kubernetes, following the thread and debugging logical replication protocols, along with some simple pg_walreceiver patches
Speaker

La Cancellera Yoann
Senior Database Performance Engineer
Percona
I am a senior database performance engineer at Percona, but I started out as a Go dev in 2018 and it’s been my daily language ever since. I assist DBAs with various issues on very large Postgres setups, be it …









