Re: WIP: Failover Slots - Mailing list pgsql-hackers

From Andres Freund
Subject Re: WIP: Failover Slots
Date
Msg-id 20160122165153.GA1276@awork2.anarazel.de
Whole thread Raw
In response to Re: WIP: Failover Slots  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: WIP: Failover Slots  (Craig Ringer <craig@2ndquadrant.com>)
Re: WIP: Failover Slots  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 2016-01-22 11:40:24 -0500, Robert Haas wrote:
> It occurred to me to wonder if it might be better to
> propagate logical slots partially or entirely outside the WAL stream,
> because with this design you will end up with the logical slots on
> every replica, including cascaded replicas, and I'm not sure that's
> what we want.  Then again, I'm also not sure it isn't what we want.

Not propagating them through the WAL also has the rather large advantage
of not barring the way to using such slots on standbys.

I think it's technically quite possible to maintain the required
resources on multiple nodes. The question is how would you configure on
which nodes the resources need to be maintained? I can't come up with a
satisfying scheme...



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: WIP: Failover Slots
Next
From: Tom Lane
Date:
Subject: Re: Fwd: Re: [DOCS] Document Upper Limit for NAMEDATELEN in pgsql 9.5+