diff options
| author | Alexander Korotkov <akorotkov@postgresql.org> | 2023-11-29 01:41:48 +0200 |
|---|---|---|
| committer | Alexander Korotkov <akorotkov@postgresql.org> | 2023-11-29 01:41:48 +0200 |
| commit | 2cdf131c46e631addfc386f6106e52a1b8cc3a70 (patch) | |
| tree | 5faf24c559be725f691b135118f20988f71c6bc1 /doc/src | |
| parent | 4ed8f0913bfdb5f3551de3c27fc2c2e880abc5a2 (diff) | |
| download | postgresql-2cdf131c46e631addfc386f6106e52a1b8cc3a70.tar.gz postgresql-2cdf131c46e631addfc386f6106e52a1b8cc3a70.zip | |
Use larger segment file names for pg_notify
This avoids the wraparound in async.c and removes the corresponding code
complexity. The maximum amount of allocated SLRU pages for NOTIFY / LISTEN
queue is now determined by the max_notify_queue_pages GUC. The default
value is 1048576. It allows to consume up to 8 GB of disk space which is
exactly the limit we had previously.
Author: Maxim Orlov, Aleksander Alekseev, Alexander Korotkov, Teodor Sigaev
Author: Nikita Glukhov, Pavel Borisov, Yura Sokolov
Reviewed-by: Jacob Champion, Heikki Linnakangas, Alexander Korotkov
Reviewed-by: Japin Li, Pavel Borisov, Tom Lane, Peter Eisentraut, Andres Freund
Reviewed-by: Andrey Borodin, Dilip Kumar, Aleksander Alekseev
Discussion: https://postgr.es/m/CACG%3DezZe1NQSCnfHOr78AtAZxJZeCvxrts0ygrxYwe%3DpyyjVWA%40mail.gmail.com
Discussion: https://postgr.es/m/CAJ7c6TPDOYBYrnCAeyndkBktO0WG2xSdYduTF0nxq%2BvfkmTF5Q%40mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 16 | ||||
| -rw-r--r-- | doc/src/sgml/ref/listen.sgml | 1 | ||||
| -rw-r--r-- | doc/src/sgml/ref/notify.sgml | 1 |
3 files changed, 18 insertions, 0 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 93735e3aea5..94d1eb2b81a 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -2151,6 +2151,22 @@ include_dir 'conf.d' </listitem> </varlistentry> + <varlistentry id="guc-max-notify-queue-pages" xreflabel="max_notify_queue_pages"> + <term><varname>max_notify_queue_pages</varname> (<type>integer</type>) + <indexterm> + <primary><varname>max_notify_queue_pages</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Specifies the maximum amount of allocated pages for + <xref linkend="sql-notify"/> / <xref linkend="sql-listen"/> queue. + The default value is 1048576. For 8 KB pages it allows to consume + up to 8 GB of disk space. + </para> + </listitem> + </varlistentry> + </variablelist> </sect2> diff --git a/doc/src/sgml/ref/listen.sgml b/doc/src/sgml/ref/listen.sgml index 2fab9d65a10..6c1f09bd455 100644 --- a/doc/src/sgml/ref/listen.sgml +++ b/doc/src/sgml/ref/listen.sgml @@ -148,6 +148,7 @@ Asynchronous notification "virtual" received from server process with PID 8448. <simplelist type="inline"> <member><xref linkend="sql-notify"/></member> <member><xref linkend="sql-unlisten"/></member> + <member><xref linkend="guc-max-notify-queue-pages"/></member> </simplelist> </refsect1> </refentry> diff --git a/doc/src/sgml/ref/notify.sgml b/doc/src/sgml/ref/notify.sgml index d7dcbea02d4..fd6ed54e8f9 100644 --- a/doc/src/sgml/ref/notify.sgml +++ b/doc/src/sgml/ref/notify.sgml @@ -228,6 +228,7 @@ Asynchronous notification "foo" with payload "payload" received from server proc <simplelist type="inline"> <member><xref linkend="sql-listen"/></member> <member><xref linkend="sql-unlisten"/></member> + <member><xref linkend="guc-max-notify-queue-pages"/></member> </simplelist> </refsect1> </refentry> |