Re: [HACKERS] Replication/backup defaults - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [HACKERS] Replication/backup defaults
Date
Msg-id CAB7nPqRmC7t=wyJO7L8pzQeZ+38_8Owyr1QzZfZ+FbzNHUjQpg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Replication/backup defaults  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: [HACKERS] Replication/backup defaults  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Re: [HACKERS] Replication/backup defaults  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On Mon, Jan 2, 2017 at 10:55 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> In the hope of making things better in 10.0, I remove my objection. If
> people want to use wal_level = minimal they can restart their server
> and they can find that out in the release notes.
>
> Should we set wal_level = replica or wal_level = logical as the
> default for 10.0?

replica sounds like a better default to me as most users use at least
archiving. Logical decoding is still fresh though, and its use is not
that wide. Have there been any study on its performance impact
compared to replica by the way?
-- 
Michael



pgsql-hackers by date:

Previous
From: Rahila Syed
Date:
Subject: Re: [HACKERS] Assignment of valid collation for SET operations onqueries with UNKNOWN types.
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] Supporting huge pages on Windows