DumBthInker007

Love your work Claire, especially on the Talking Postgres podcast. I actually wanted to say this in person when you were at PGConf India 2025, but couldn’t quite manage. BTW, my first episode was the one with Tom Lane and been hooked ever since.

My understanding: i think as postgres takes an exclusive lock to enqueue the notifications into a shared queue in PreCommit_Notify(), as the actual commit happens after notification was enqueued into the queue,as other transactions also try to notify but wait becacause of the lock ,so does the commit waits.

this post was kind of the other way around https://news.ycombinator.com/item?id=43886414

Thanks for sharing.

Hi thanks for the reply ,i guess there was some ongoing work for this and for some reason it didn't continued this is the thread https://www.postgresql.org/message-id/flat/CAJcOf-cXnB5cnMKq... if you are interested in, but for sure i will look into this(added to my list:).

I am aiming to contribute meaningfully to the postgres project, to learn and grow as a Postgres hacker, I want to hear directly from you—PostgreSQL users—about the problems you face, big or small.

I created this "ASK HN" post https://news.ycombinator.com/item?id=43886414 please share your feedback.

Thanks for the reply,will surely look into it.

thanks for sharing.

thanks for the quick reply, will surely look into it.