Post

Wow, TIL that LISTEN/NOTIFY in Postgres requires a global lock when committing transactions issuing a NOTIFY. Consider listening to the WAL via logical replication as an alternative with no impact on the write path. www.recall.ai/blog/postgre...

11/7/25, 7:09 am6 reposts19 likes

Dennis Reichenberg

@bananen.software

11 July 2025

Thanks for sharing, that is a huge downside I wasn't aware of either.

Chris

@chris.blue

12 July 2025

You’re sure spending a lot of time with PG. What are you up to? 🧐

Gunnar Morling

@gunnarmorling.dev

12 July 2025

Haha, good question. Having some new ideas around CDC for Postgres. For a while I thought there's no more juice to squeeze, but I think I'm coming around.