Amazon RDS for PostgreSQL: What’s New and Lessons Learned
Grant McAlister is a Senior Principal Engineer at Amazon Web Services where he works on RDS - Amazon's Relational Database Service, the service he helped found 8 years ago. Prior to AWS, Grant was responsible for the performance, scalability and availability of Amazon's databases. Before joining Amazon.com in 1999, Grant worked as an Independent Database Consultant and as a Senior Principle Consultant for Oracle Corporation. He earned a B.S. in Computer Science at the University of Alberta.
In this session we will begin with a quick overview of the Amazon RDS service and how it achieves durability and high availability. Then we will do a deep dive into the exciting new features we recently released, including 9.6, snapshot sharing, enhancements to encryption, vacuum, and replication. We will also explore lessons we have learned managing a large fleet of PostgreSQL instances, including important tunables and possible gotchas around pg_upgrade. During the session we also briefly cover our newly announced Aurora PostgreSQL compatible edition. We will wrap up the session with benchmarking of new RDS instance classes, and the value proposition of these new instance types.
- 2017 March 30 10:00
- 50 min
- PGConf US 2017