Re: q re removal/recycling of WAL files

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: q re removal/recycling of WAL files
Дата
Msg-id D1A01608-4D0A-4AD5-BAB0-980B7B68FE7A@elevated-dev.com
обсуждение исходный текст
Ответ на Re: q re removal/recycling of WAL files  (Rui DeSousa <rui@crazybean.net>)
Список pgsql-admin
> On Nov 3, 2021, at 5:37 PM, Rui DeSousa <rui@crazybean.net> wrote:
>
> WAL file can’t be recycled until it is no longer needed; thus after a checkpoint and archived as well (if enabled).


Ah yes, that's it! We are archiving WAL, and I imagine what happened easily outran the pace of archiving.

There was an exponential backoff between the retries, so although I could imagine rapid-fire retries filling disk with
WALbefore checkpoint running, I was having a little doubt about that happening in this case. I'm sure it was the
archiving.




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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: q re removal/recycling of WAL files
Следующее
От: Karl Denninger
Дата:
Сообщение: Re: Encoding error during database restore