Backup and restore performance can be improved in different ways, depending on the backup type:
- Physical backup: Improving the performance of a physical backup can be done by performing the backup in parallel and copying the files using more than one task. The more tasks you use, the more it will impact the current system. When backing up, you can skip certain files. You won't need the following:
- Any files placed in the data directory by DBA that shouldn't actually be there
- Any files in pg_wal
- Any old server log files in pg_log (even the current one)
Remember, it's safer not to try to exclude files at all because, if you miss something critical, you may end up with data loss. Also remember that your backup speed may be ...
