Re: Notes on testing Postgres 10b1

From: Andres Freund <andres(at)anarazel(dot)de>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Josh Berkus <josh(at)berkus(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Notes on testing Postgres 10b1
Date: 2017-06-07 05:32:43
Message-ID: 20170607053243.yo26gkyj6agdqweh@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2017-06-07 14:29:04 +0900, Michael Paquier wrote:
> On Wed, Jun 7, 2017 at 2:01 PM, Josh Berkus <josh(at)berkus(dot)org> wrote:
> > Q1. Why does wal_level default to "replica" and not "logical"?
>
> The difference of WAL generated is way higher between
> archive->hot_standby than hot_standby->logical. And unlike replica,
> logical decoding is not something that is widely spread in user's
> deployments to justify changing to such a default. At least that's
> what I recall on the matter.

Right. I think what we really want there is some form of magic
switching to logical when a slot is present. Thats easy enough on the
master, a good bit harder when we allow decoding on standbys, which
Craig's working on.

> > Q2: I thought we were going to finally change the pg_dump default to
> > "custom" format in this release? No?
>
> I don't recall any discussion on this matter, but my memory may fail me.

Nothing here either.

- Andres

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2017-06-07 05:36:26 Re: PG10 transition tables, wCTEs and multiple operations on the same table
Previous Message Michael Paquier 2017-06-07 05:29:04 Re: Notes on testing Postgres 10b1