Postgres max notification size

[narrowtux]

PostgreSQL has a maximum notification payload size of 8000 bytes by default. Anything above will result in an error.

I have successfully worked around this by chunking the payload before broadcasting it and then concatenating it agtain when it is received by other endpoints. I will probably submit a pull request to make this pubsub adapter more stable.

Excerpt from the PostgreSQL documentation:

The "payload" string to be communicated along with the notification. This must be specified as a simple string literal. In the default configuration it must be shorter than 8000 bytes. (If binary data or large amounts of information need to be communicated, it's best to put it in a database table and send the key of the record.)

[elimisteve]

@narrowtux Hey there, make any progress on this? I will likely need to exceed the 8000-byte limit soon and I'm looking for solutions, thanks.

[narrowtux]

no, I switched companies with a different tech stack.