Back to Supabase

How Long Does It Take To Restore A Database From A Point In Time Backup Pitr QO8gOG

apps/docs/content/troubleshooting/how-long-does-it-take-to-restore-a-database-from-a-point-in-time-backup-pitr-qO8gOG.mdx

1.26.04499 B
Original Source

The time required for a PIT restoration isn't fixed. It depends on several factors:

Time Since Last Full Backup:

Full backups occur weekly. The time elapsed since the last full backup can affect restoration time.

Write-Ahead Logging (WAL) Activity:

The volume of WAL activity since the last full backup is a critical factor. More activity can lead to longer restoration times.

Database Size:

While important, the size of the database isn't the sole determinant of restoration time.