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...
Post
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.
0 reposts4 likes
No replies yet.