Re: Logical replication use cases

Поиск
Список
Период
Сортировка
От Sushant Pawar
Тема Re: Logical replication use cases
Дата
Msg-id CAF2=t-rCr1W=Bx8vbRXu3OOhqY4RtbXR4g4G02AGHEaxB=rMdg@mail.gmail.com
обсуждение исходный текст
Ответ на Logical replication use cases  (Yambu <hyambu@gmail.com>)
Список pgsql-admin
Logical replication is useful for doing selective data replication. If the requirement is just to replicate a subset of data then logical replication will help. Also logical replication can be useful if you plan to build the data hub that will get data from multiple source Postgres instances.

The logical replication will result in more WAL generation but replication is almost real time.

On Wed, Jan 6, 2021 at 7:03 PM Yambu <hyambu@gmail.com> wrote:
Hello

May i know if i can use logical replication in any circumstance? Is it a good replacement for physical replication and does it work well in high volume transactions?

regads

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

Предыдущее
От: Michael Banck
Дата:
Сообщение: Re: master and slave at same time
Следующее
От: Scott Ribe
Дата:
Сообщение: quick q re migration, index, stats