Snapshotting at intervals is how most point-in-time restores scale up. The db is snapshotted at a preset time (easy way: lock db for writes whilst snap is in p

Snapshotting at intervals is how most point-in-time restores scale up. The db is snapshotted at a preset time (easy way: lock db for writes whilst snap is in progress, preferably on read replicas) and then restored again (preferably, elsewhere) to see if restore did indeed work as expected (and isn't corrupt). The latest log sequence number could also be stored in the same db (in a separate table) so that it is captured along with the db-snapshot, atomically.