Search code examples
postgresqlstreamingreplication

Postgres Streaming Replication Bandwidth Estimation


Is there a standard way of estimating what total bandwidth requirements are between a primary and replica using streaming replication? I understand we can take the size and number of the WAL files but I also understand that using streaming replication data is propagated ahead of the WAL file being filled so I assume that there is a streamed + WAL file type calculation to perform. Short of tracking the data at the network level is there a rough way to calculate the requirement?

Thanks

Simon


Solution

  • WAL information is not transferred using log file shipping, but it is still the same WAL. So the amount of WAL written to the log files is a good measure for the required bandwidth.