diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-07-07 13:08:00 -0400 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-07-07 13:08:00 -0400 |
| commit | a8aaa0c786b3a27706172cc7979684a122ebb706 (patch) | |
| tree | a07ceaa91d72f50d935618bdfce26ecb5787250d /doc/src | |
| parent | 6a5c750f3f72899f4f982f921d5bf5665f55651e (diff) | |
| download | postgresql-a8aaa0c786b3a27706172cc7979684a122ebb706.tar.gz postgresql-a8aaa0c786b3a27706172cc7979684a122ebb706.zip | |
Morph pg_replication_slots.min_safe_lsn to safe_wal_size
The previous definition of the column was almost universally disliked,
so provide this updated definition which is more useful for monitoring
purposes: a large positive value is good, while zero or a negative value
means danger. This should be operationally more convenient.
Backpatch to 13, where the new column to pg_replication_slots (and the
feature it represents) were added.
Author: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
Reported-by: Fujii Masao <masao.fujii@oss.nttdata.com>
Discussion: https://postgr.es/m/9ddfbf8c-2f67-904d-44ed-cf8bc5916228@oss.nttdata.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 003d2783703..361793b337a 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -11275,10 +11275,13 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx <row> <entry role="catalog_table_entry"><para role="column_definition"> - <structfield>min_safe_lsn</structfield> <type>pg_lsn</type> + <structfield>safe_wal_size</structfield> <type>int8</type> </para> <para> - The minimum LSN currently available for walsenders. + The number of bytes that can be written to WAL such that this slot + is not in danger of getting in state "lost". It is NULL for lost + slots, as well as if <varname>max_slot_wal_keep_size</varname> + is <literal>-1</literal>. </para></entry> </row> </tbody> |