pgsql: doc: Add note about promotion waits on backends stuck sending to

Поиск
Список
Период
Сортировка
Искать

pgsql: doc: Add note about promotion waits on backends stuck sending to

От:
Masahiko Sawada <msawada@postgresql.org>
Дата:
doc: Add note about promotion waits on backends stuck sending to clients.

Commit df1be4ddc83 made promotion skip waiting for the barrier that
refreshes each process's cached logical WAL logging state in some
cases, but promotion still waits for it on a standby with wal_level =
replica that has a valid logical slot. A backend blocked sending data
to a client that has stopped reading can't process the barrier, so
promotion can wait for a long time.

Add a note about this case in the failover section, along with ways to
get out of the wait and to bound it in advance.

Backpatch to v19, where commit 67c20979ce7 introduced this wait.

Author: shihao zhong 
Reviewed-by: Amit Kapila 
Reviewed-by: Hayato Kuroda 
Reviewed-by: shveta malik 
Reviewed-by: Zhijie Hou 
Reviewed-by: Masahiko Sawada 
Discussion: https://postgr.es/m/CAGRkXqToBk9c2sPAgha-kCgxJhVwn90j1sCyUXrvydq51LKAqA@mail.gmail.com
Backpatch-through: 19

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/f0d493168436eddbf24024437ddec253ca774e86

Modified Files
--------------
doc/src/sgml/high-availability.sgml | 32 ++++++++++++++++++++++++++++++++
1 file changed, 32 insertions(+)

FAQ