Re: Estimating wal_keep_size

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: Estimating wal_keep_size
Дата
Msg-id CAOBaU_a-BanEBN=5cP8UP92Cw7Yst-okmHYi9o1hYU9ZfuASHA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Estimating wal_keep_size  ("Dean Gibson (DB Administrator)" <postgresql@mailpen.com>)
Ответы Re: Estimating wal_keep_size
Список pgsql-performance
Le sam. 19 juin 2021 à 02:13, Dean Gibson (DB Administrator) <postgresql@mailpen.com> a écrit :

Granted, but the same question arises about the value for max_slot_wal_keep_size.  Setting either too low risks data loss, & setting either too high results in unnecessary disk space used.  The question was, is the estimated VALUE reasonable under the circumstances?

it may be, until one day it won't be. and that day usually happens. when you set up this kind of limit you choose service availability over your data, so you have to accept that it may not be enough. if this is a problem don't setup a limit. 

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

Предыдущее
От: "Dean Gibson (DB Administrator)"
Дата:
Сообщение: Re: Estimating wal_keep_size
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: Estimating wal_keep_size