Re: Multi-Master Logical Replication

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Multi-Master Logical Replication
Дата
Msg-id YpYg608FcI+knMTw@momjian.us
обсуждение исходный текст
Ответ на Re: Multi-Master Logical Replication  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Multi-Master Logical Replication  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On Wed, May 25, 2022 at 10:32:50PM -0400, Bruce Momjian wrote:
> On Wed, May 25, 2022 at 12:13:17PM +0530, Amit Kapila wrote:
> > > You still have not answered my question above.  "Without these features,
> > > what workload would this help with?"  You have only explained how the
> > > patch would fix one of the many larger problems.
> > >
> > 
> > It helps with setting up logical replication among two or more nodes
> > (data flows both ways) which is important for use cases where
> > applications are data-aware. For such apps, it will be beneficial to
> 
> That does make sense, thanks.

Uh, thinking some more, why would anyone set things up this way ---
having part of a table being primary on one server and a different part
of the table be a subscriber.  Seems it would be simpler and safer to
create two child tables and have one be primary on only one server. 
Users can access both tables using the parent.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: PostgreSQL Limits: maximum number of columns in SELECT result
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: PostgreSQL Limits: maximum number of columns in SELECT result