Postgres Streaming Replication Bandwidth Estimation

Simon Taylor 0
Viewed 13

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

replication streaming postgresql
1 Answers

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.

Laurenz Albe0
Related