diff options
| author | Fujii Masao <fujii@postgresql.org> | 2020-07-03 12:08:35 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2020-07-03 12:08:35 +0900 |
| commit | 8f9b6d40570bd8991f18a089a8445cc5275c1f49 (patch) | |
| tree | 1c1bedb20a39d9487214dddb8d2ba4f1c75673d7 /doc/src | |
| parent | d1763ea8c9c32837d373a196ed0c2e1256a55824 (diff) | |
| download | postgresql-8f9b6d40570bd8991f18a089a8445cc5275c1f49.tar.gz postgresql-8f9b6d40570bd8991f18a089a8445cc5275c1f49.zip | |
doc: Correct description of restart_lsn in pg_replication_slots
Previously the document explained that restart_lsn indicates the LSN of
oldest WAL won't be automatically removed during checkpoints. But
since v13 this was no longer true thanks to max_slot_wal_keep_size.
Back-patch to v13 where max_slot_wal_keep_size was added.
Author: Fujii Masao
Discussion: https://postgr.es/m/6497f1e9-3148-c5da-7e49-b2fddad9a42f@oss.nttdata.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 49a881b2621..003d2783703 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -11214,7 +11214,9 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx <para> The address (<literal>LSN</literal>) of oldest WAL which still might be required by the consumer of this slot and thus won't be - automatically removed during checkpoints. <literal>NULL</literal> + automatically removed during checkpoints unless this LSN + gets behind more than <xref linkend="guc-max-slot-wal-keep-size"/> + from the current LSN. <literal>NULL</literal> if the <literal>LSN</literal> of this slot has never been reserved. </para></entry> </row> |