Managing backup speed

[stalkerg]

For reduce load for server in some case.

[asnytko]

Are there plans to add a file transfer rate limit as in pg_basebackup (--max-rate key)? Any progress?

[gsmolk]

Not yet, but since somebody takes interest in this feature, I will look into it.

[asnytko]

We have Patroni clusters. Backups are executed on the sync replica. It is not possible to run it on async replica.

Shared data storage system. Customers get a certain quality of service (QoS), which depends on the size of the database. The larger the size of the database, the higher the I/O and IOPS limit.

There are problems on small databases while the backup running. It runs in a single thread, but it still recycles the I/O quota. This causes lag between the synchronous replica and the master. Requests hang on the SyncRep event.

The feature to control file transfer rate would really help us.