pgsql: Fix calculation for WAL segment recycling and removal

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема pgsql: Fix calculation for WAL segment recycling and removal
Дата
Msg-id E1fhmK4-0001l7-HH@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix calculation for WAL segment recycling and removal

Commit 4b0d28de06 has removed the prior checkpoint and related
facilities but has left WAL recycling based on the LSN of the prior
checkpoint, which causes incorrect calculations for WAL removal and
recycling for max_wal_size and min_wal_size.  This commit changes things
so as the base calculation point is the last checkpoint generated.

Reported-by: Kyotaro Horiguchi
Author: Kyotaro Horiguchi
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/20180723.135748.42558387.horiguchi.kyotaro@lab.ntt.co.jp
Backpatch: 11-, where the prior checkpoint has been removed.

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/9915735ebbc5c5362f5834f6ad7b86394ded4a85

Modified Files
--------------
src/backend/access/transam/xlog.c | 159 +++++++++++++++++++-------------------
1 file changed, 78 insertions(+), 81 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: pgsql: Use setproctitle_fast() to update the ps status, if available.
Следующее
От: Michael Paquier
Дата:
Сообщение: pgsql: Refactor cluster_rel() to handle more options