Hey everyone! I'm currently assessing Aurora Postgres as a potential database solution for one of my applications. I'm particularly interested in any performance benchmarking documentation that covers point-in-time restore (PITR) features. I'm trying to get a sense of how long the recovery process might take, as well as what factors could potentially influence that time. Just for context, our database size is significant at 24 TB, so any insights specific to handling such large data would be super helpful!
2 Answers
You might want to check out these resources for more in-depth info:
- [AWS Databases](https://aws.amazon.com/products/databases/)
- [RDS Documentation](https://aws.amazon.com/rds/)
- [Aurora Overview](https://aws.amazon.com/aurora/)
These pages should provide you with additional context that might help your evaluation.
When performing a PITR, the process starts with restoring the latest full snapshot before your specified point in time. After that, it applies archive logs up until your chosen time. Given your database's large size, ensure you're using a powerful instance to optimize the EBS throughput. The time to restore those archive logs will mainly depend on how much data has been changed, as larger logs will take longer.
Related Questions
Fix Not Being Able To Add New Categories With Intuitive Category Checklist For Wordpress
Get Real User IP Without Installing Cloudflare Apache Module
How to Get Total Line Count In Visual Studio 2013 Without Addons
Install and Configure PhpMyAdmin on Centos 7
How To Setup PostfixAdmin With Dovecot and Postfix Virtual Mailbox
Dovecot Error Unknown database driver mysql