Re: WIP: Failover Slots

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: WIP: Failover Slots
Дата
Msg-id 20160122165153.GA1276@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: WIP: Failover Slots  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: WIP: Failover Slots
Re: WIP: Failover Slots
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: WIP: Failover Slots
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Fwd: Re: [DOCS] Document Upper Limit for NAMEDATELEN in pgsql 9.5+