Re: Defaults for replication/backup

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Defaults for replication/backup
Дата
Msg-id 20160213133947.GB29473@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: Defaults for replication/backup  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: Defaults for replication/backup  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
On 2016-02-13 22:37:33 +0900, Michael Paquier wrote:
> On Sat, Feb 13, 2016 at 10:15 PM, Magnus Hagander wrote:
> > So, I suggest the following changes to the defaults:
> > wal_level=hot_standby
> > max_wal_senders=10
> > max_replication_slots=10

+1. I'm inclined to set slots a bit higher than senders. They're pretty
cheap...

I think this is way past due.

> 10 seems a bit high. I would think that max_wal_senders and
> max_replication_slots set at 3 are sufficient enough, giving enough
> room for simple deployments willing to use replication.

But they're relatively cheap to enable, so why set them low?


Andres



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Defaults for replication/backup
Следующее
От: Greg Stark
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Add some isolation tests for deadlock detection and resolution.