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 ------ master Details ------- https://git.postgresql.org/pg/commitdiff/b936425002c54abab86dab151efdbb6952314388 Modified Files -------------- doc/src/sgml/high-availability.sgml | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+)