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.
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?
