Re: [HACKERS] Replication/backup defaults

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: [HACKERS] Replication/backup defaults
Дата
Msg-id CABUevEyUZN63_zXtZM5EoYkq55TDUge9vvRbD7V288cOFWuJ-w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Replication/backup defaults  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: [HACKERS] Replication/backup defaults  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers


On Wed, Jan 4, 2017 at 3:43 PM, Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote:
On 12/31/16 10:00 AM, Magnus Hagander wrote:
> max_wal_senders=10
> max_replication_slots=20

How about we default max_replication_slots to -1, which means to use the
same value as max_wal_senders?

I think this would address the needs of 99% of users.  If we do like you
suggest, there are going to be very many users who forget to adjust
these two values together, and very many who will do it but will be
puzzled and annoyed by it.  Since we're now pushing the use of
replication slots even more (your pg_basebackup change, upcoming logical
replication), I think this could be a major source of misconfigurations.

But you don't necessarily want to adjust them together, do you? They are both capped by max_connections, but I don't think they have any other direct relation between each other? 

--

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] Replication/backup defaults
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] [PATCH] Reload SSL certificates on SIGHUP