Logical replication use cases

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Logical replication use cases

Yambu
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
Reply | Threaded
Open this post in threaded view
|

Re: Logical replication use cases

Sushant Pawar-2
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 <[hidden email]> 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