Neon describes timestamp-based branch restores for Lakebase Postgres

Lakebase Postgres uses a different path for restoring an earlier database state: create a branch at the chosen timestamp instead of copying data to a new disk. The post describes this as a metadata operation, rather than a multi-hour process of copying and replaying data. It says the method can reduce restore time to seconds, even for a database of 100 TB, and that an agent can carry out the operation.

The design separates Postgres compute from durable storage, with the systems connected through write-ahead logging. Compute runs Postgres, handling tasks such as SQL and generating WAL, but does not hold the durable copy of the data. Safekeepers receive WAL, and a transaction is durable after a quorum has acknowledged its record. The pageserver turns WAL into pages and can reconstruct one for a given key and log sequence number, while object storage retains long-term history.

That contrasts with the conventional point-in-time recovery path described in the post: deploy a new instance, restore a snapshot from before the target time, then replay archived WAL to reach that time. The source says snapshot data must be brought onto the database volume, and that queries may have high latency while needed pages are still in object storage. It says recovery for a large database can take hours, with WAL replay adding time depending on how much activity occurred after the snapshot.

The post also reports a survey of 50 developers running production Postgres: 59% said they had a critical production failure in the prior 12 months, 30% were down for at least three hours, and 21% recovered in under 60 minutes. These figures provide context for the recovery problem the branch approach is intended to address, but the article presents them as survey results rather than independent testing of the restore method. For AI builders, the described capability offers a way to inspect an earlier database state without first waiting for a conventional restore; the post specifically says an agent can perform the branch operation.