Re: Doc about how to set max_wal_senders when setting minimal wal_level

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Doc about how to set max_wal_senders when setting minimal wal_level
Дата
Msg-id CAKFQuwaYouqRcU3j8Pjr_5Zm76AQHO72a-w7mjk+n9HzWAQ54Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Doc about how to set max_wal_senders when setting minimal wal_level  (Japin Li <japinli@hotmail.com>)
Список pgsql-hackers
On Fri, Jul 15, 2022 at 6:27 AM Japin Li <japinli@hotmail.com> wrote:

>
> +        servers.  If setting <varname>max_wal_senders</varname> to
> +        <literal>0</literal> consider also reducing the amount of WAL produced
> +        by changing <varname>wal_level</varname> to <literal>minimal</literal>.
>
> I don't think this is great advice.  It will encourage people to use
> wal_level = minimal even if they have other requirements that weigh
> against it.  If they feel that their system is producing too much
> WAL, I doubt they'll have a hard time finding the wal_level knob.
>

Agreed. It isn't good advice.  We can remove the suggestion.


Yeah, I wrote that thinking that max_wal_senders being set to 0 implied archive_mode = off, but that isn't the case.

David J.

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

Предыдущее
От: Zhenghua Lyu
Дата:
Сообщение: Adjust ndistinct for eqjoinsel
Следующее
От: Aleksander Alekseev
Дата:
Сообщение: Re: Add 64-bit XIDs into PostgreSQL 15