Re: WAL "low watermark" during base backup

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WAL "low watermark" during base backup
Дата
Msg-id 22600.1314989545@sss.pgh.pa.us
обсуждение исходный текст
Ответ на WAL "low watermark" during base backup  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
> Attached patch implements a "low watermark wal location" in the
> walsender shmem array. Setting this value in a walsender prevents
> transaction log removal prior to this point - similar to how
> wal_keep_segments work, except with an absolute number rather than
> relative. For now, this is set when running a base backup with WAL
> included - to prevent the required WAL to be recycled away while the
> backup is running, without having to guestimate the value for
> wal_keep_segments. (There could be other ways added to set it in the
> future, but that's the only one I've done for now)

I agree with that parenthetical remark, ie that we'll probably consider
other uses for this in future, so I'd suggest changing this one comment:

> +  * Also check if there any in-progress base backup that has set
> +  * a low watermark preventing us from removing it.

Just say "if any WAL sender has a low watermark that prevents us from
removing it".

Looks reasonably sane otherwise, modulo Jaime's comment about the
missing reset step.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PATCH: regular logging of checkpoint progress
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: sha1, sha2 functions into core?