Company
Date Published
Author
Carlota Soto
Word count
1393
Language
English
Hacker News points
None

Summary

Neon's instant Point-in-Time Recovery (PITR) feature stands out for its ability to quickly and efficiently restore multi-terabyte databases to any past state without data copying, leveraging a unique storage architecture. Unlike traditional systems like AWS RDS that require creating a new database instance and replaying transaction logs—a process that can be time-consuming and resource-intensive—Neon adopts a branch-based approach. This method utilizes a multi-tenant storage system with WAL safekeepers, pageservers, and cloud object storage, allowing for instant restores by creating a new database branch at a specific Log Sequence Number (LSN) without duplicating data. This architecture is characterized by the separation of compute and storage, where compute nodes operate without local persistence, and all data changes are streamed and managed through a highly available and durable storage layer. With this setup, Neon's PITR provides a faster, more scalable recovery option that is particularly advantageous for large-scale databases, offering significant time and cost savings.