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 | c54b5891f415df36809de1aeb97e4574d5456d69 (patch) | |
| tree | 54c89c84b8ae4651bb9ba66254114ca8aa02b997 /doc/src | |
| parent | da6b6ff95bcaadc109ab248471527a2511e853d5 (diff) | |
| download | postgresql-c54b5891f415df36809de1aeb97e4574d5456d69.tar.gz postgresql-c54b5891f415df36809de1aeb97e4574d5456d69.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 198ed62e96f..8ff17d9b4e0 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> |