Re: Size limit for NOTIFY payload - Mailing list pgsql-docs

From Greg Sabino Mullane
Subject Re: Size limit for NOTIFY payload
Date
Msg-id CAKAnmmLX=FzrWSzN1eB6Se54sWUm7J44h+3WvbxjZM5rR+DvxQ@mail.gmail.com
Whole thread Raw
In response to Re: Size limit for NOTIFY payload  (sulfinu@gmail.com)
List pgsql-docs
On Fri, Dec 20, 2024 at 5:53 AM <sulfinu@gmail.com> wrote:
Well, as I said, that's a text value with a byte limit. The documentation should definitely mention something like "with the default database encoding".

I'm not sure why you think adding such wordage is needed. Bytes is bytes. Your application should be checking the number of bytes in the string sent to NOTIFY.

On a related note, if you find yourself approaching the payload limits, you might want to rethink the way you are using LISTEN/NOTIFY.

Cheers,
Greg


 

pgsql-docs by date:

Previous
From: sulfinu@gmail.com
Date:
Subject: Re: Size limit for NOTIFY payload
Next
From: jian he
Date:
Subject: restart-footnote-numbering-in-each-sect1