Postgres in Amazon RDS
summary
Amazon RDS runs Postgres Postgres 9.3 as a managed, production-ready service with automatic backups, SSL on by default, and built-in monitoring, but it forbids SSH and superuser access so custom extensions and on-server tools are unusable. Multi-AZ gives automated failover at roughly a 10% performance cost and about 10–20% price premium. Read replicas for Postgres are missing, point-in-time restores create new instances, extensions like pg_stat_statements and PostGIS are available, and provisioning IOPS changes (examples show doubling IOPS can take around an hour) happen online but not instantly.
AI-written summary · about
chapters (21)
- 0:00Introduction
- 1:00Who am I
- 4:22Service Highlights
- 5:52Instance Setup
- 12:58Instance Parameters
- 16:24Parameter Group
- 17:42Automatic software patching
- 19:23Snapshots
- 26:14Multiregion Replication
- 27:30Multiregion Slave
- 28:21Provision IOPS
- 32:42Isolation Security
- 34:11Instance Monitoring
- 36:12Automatic host replacements
- 37:47Monitoring logs
- 39:47Postgres extensions
- 44:10Performance
- 45:36Limitations
- 47:00Pricing
- 49:03DBT
- 49:22Surge
related talks
41mRunning Highly Available Postgres in AWS RDS
18mPostgreSQL at Amazon
19mPostgreSQL at Amazon
40mPushing past PostgreSQL’s vertical scaling limits - Running Amazon RDS
10mPostgres on AWS: Run 5X faster on metal, migrate anywhere
54mBreakout Session
14mBuilding a better PostgreSQL together
49mDeploying Highly Available, Durable Amazon RDS for PostgreSQL and for MySQL Databases