Maximum Performance
Updates committed to primary and sent to standby without waiting to see if they were applied to standby
Pros: Little or no effect on performance of primary
Cons: Slight chance of lost transactions (on failover)
Maximum Availability
Attempts to apply updates to standby before committed to primary
Lowers protection to Maximum Performance temporarily if updates can’t be applied to standby
Pros: Primary continues unaffected if connection to standby is lost or the updates are delayed
Cons: Slight performance hit on primary; lost transactions on failover possible only if the standby has been unreachable
Maximum Protection
Assures updates are applied to standby before committed to primary
Pros: No chance of lost transactions
Cons: Primary will freeze if connection to standby is lost or the updates are delayed