Top
Enterprise Postgres 17 Installation and Setup Guide for Server

E.6 Estimating Backup Disk Space Requirements

This section provides the formula for estimating backup disk space requirements.

Backup disk space requirements = size of the database cluster x 2 x compression ratio
                                     + transaction log space requirements + archive log space requirements

Note

If the pgx_dmpall command performs a backup using a user command, the backup disk size differs according to the database resources targeted for backup and the copy method.

When using compression, the compression ratio depends on the data. Therefore, measure the actual compression ratio by using a test environment to simulate backup scheduling and database update in a real operating environment. Specify 1 to not use compression.