How long does it take to restore a database from a Point-in-Time backup (PITR)?
PIT修复所需的时间不是固定的。这取决于几个因素:
🌐 The time required for a PIT restoration isn't fixed. It depends on several factors:
自上次完整备份以来的时间:
完整备份每周进行一次。自上次完整备份以来的时间会影响恢复时间。
🌐 Full backups occur weekly. The time elapsed since the last full backup can affect restoration time.
预写式日志 (WAL) 活动:
自上次完整备份以来的 WAL 活动量是一个关键因素。活动越多,恢复时间可能越长。
🌐 The volume of WAL activity since the last full backup is a critical factor. More activity can lead to longer restoration times.
数据库大小:
虽然重要,但数据库规模并非恢复时间的唯一决定因素。
🌐 While important, the size of the database isn't the sole determinant of restoration time.