Thread: Logical replication use cases
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
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:
HelloMay 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