Re: Defaults for replication/backup - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Defaults for replication/backup
Date
Msg-id 20160213133947.GB29473@awork2.anarazel.de
Whole thread Raw
In response to Re: Defaults for replication/backup  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Defaults for replication/backup
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Defaults for replication/backup
Next
From: Greg Stark
Date:
Subject: Re: [COMMITTERS] pgsql: Add some isolation tests for deadlock detection and resolution.