PostgreSQL LISTEN/NOTIFY Queue Full: A 512 KiB Reproduction
What causes PostgreSQL to report: ERROR: too many notifications in the NOTIFY queue I reproduced it with PostgreSQL 17, Docker, and two psql sessions. Instead of trying to fill PostgreSQL's default multi-gigabyte queue, I started the server with: max_notify_queue_pages=64 With 8 KiB pages, that gave the experiment a queue capacity of only 512 KiB . The listener did this: LISTEN demo ; BEGIN ; and…
We haven't written up this one. Dev.to has the full story — the link below goes straight to it.
