Best usecase of Logical Replication

Jo aapdne khyal nathi k logical replication kyare use karvu joie to aapde aeno vadhare faido na lai sakie. to chalo janie k kyare aapde logical replication no use kari sakie and kai rite use kari sakie.

When to use it?

• Need flexiblity: logical replication ma bau vadhare restriction nathi k banne primary and standby/replica cluster and database na tables ni schema same j hovi joie. actually ma banne jo alag alag version na database hoi to bhi chale. aapde ek primary linux ma 6e and replica windows ma 6e to bhi aapde aa logical replica no benefit lai sakie 6ie. In short, Flexiblity ni jarur hoi tyare aapde aa use kari sakie 6ie. jyare aapde particular koi ek type na operations mate listen karvu hoi tyare bhi use kari sakie 6ie jem k insert only, update only, etc...
• Fine-grained control: aapde increamental changes subscriber ne moklavi sakie 6ie. aapde individual triggers bhi set kari sakie 6ie jyare koi changes subscriber ne male 6e tyare. aapde alag alag users na group ne replicated data no access aapi sakie 6ie.
• High performance: physical replica na hova ne karne bau saru performance bhi male 6e and network bhi bau low joie 6e.