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

Summary

The challenges of recovering a 100 TB Postgres database in AWS RDS highlight the limitations of traditional recovery methods, such as snapshot-based backup and Multi-AZ standbys, in large-scale environments. AWS RDS offers point-in-time recovery (PITR) through snapshots stored in Amazon S3 and WAL replay, but this process can be slow, taking hours to restore significant amounts of data. Multi-AZ deployments provide high availability through redundancy but do not address PITR, and they may experience replication lag at large scales. Neon offers an alternative with its innovative Postgres architecture, featuring instant PITR and built-in high availability without dedicated standby instances. By separating storage and compute, and using a log-structured storage system, Neon enables fast recovery and efficient data management, making it a cost-effective and reliable option for managing large databases.