Top
Enterprise Postgres 17 Installation and Setup Guide for Server

E.4 Estimating Transaction Log Space Requirements

This section provides the formula for estimating transaction log space requirements.

Transaction log space requirements = max_wal_size

However, if the update volume is extremely high (for example, due to a large data load and batch processing), disk writing at a checkpoint may not be able to keep up with the load, and a higher number of transaction logs than indicated here may temporarily be accumulated.