| From: | Sushant Pawar <sushantxp(at)gmail(dot)com> |
|---|---|
| To: | Yambu <hyambu(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Logical replication use cases |
| Date: | 2021-01-06 15:03:41 |
| Message-ID: | CAF2=t-rCr1W=Bx8vbRXu3OOhqY4RtbXR4g4G02AGHEaxB=rMdg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2021-01-06 16:41:40 | quick q re migration, index, stats |
| Previous Message | Michael Banck | 2021-01-06 13:36:50 | Re: master and slave at same time |