From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | Simon Riggs <simon(dot)riggs(at)2ndquadrant(dot)com>, Thom Brown <thom(at)linux(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Logical decoding on standby |
Date: | 2017-03-22 22:55:53 |
Message-ID: | CAMsr+YHCca+Cry_JoWGDHtpCR-ysD=y=KRefOLG9WS-semMZuA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 22 March 2017 at 21:06, Andres Freund <andres(at)anarazel(dot)de> wrote:
> Hi,
>
> On 2017-03-21 09:05:26 +0800, Craig Ringer wrote:
>> > 0002 should be doable as a whole this release, I have severe doubts that
>> > 0003 as a whole has a chance for 10 - the code is in quite a raw shape,
>> > there's a significant number of open ends. I'd suggest breaking of bits
>> > that are independently useful, and work on getting those committed.
>>
>> That would be my preference too.
>
>
>> The parts I think are important for Pg10 are:
>
>> * Ability to create logical slots on replicas
>
> Doesn't this also imply recovery conflicts on DROP DATABASE? Besides,
> allowing to drop all slots using a database upon DROP DATABASE, is a
> useful thing on its own.
Definitely beneficial, otherwise recovery will stop until you drop
slots, which isn't ideal.
>> * Ability to advance (via feedback or via SQL function) - no need to
>> actually decode and call output plugins at al
>
> That pretty much requires decoding, otherwise you really don't know how
> much WAL you have to retain.
Yes, and to update restart_lsn and catalog_xmin correctly.
I was thinking that by disallowing snapshot use and output plugin
invocation we'd avoid the need to support cancellation on recovery
conflicts, etc, simplifying things considerably.
>> * Ability to drop logical slots on replicas
>
> That shouldn't actually require any changes, no?
It doesn't, it works as-is. I have NFI why I wrote that.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2017-03-22 23:31:31 | Re: Logical decoding on standby |
Previous Message | Michael Paquier | 2017-03-22 22:09:47 | Re: exposing wait events for non-backends (was: Tracking wait event for latches) |