One thing to know if you’re using this Postgres feature is that the max payload is 8000 bytes [1]

That was the initial implementation for supabase’s real-time updates (afaik) and for this reason they had to resort to read the WAL.

[1] https://www.postgresql.org/docs/9.4/sql-notify.html