Breakout Session
summary
Amazon RDS for PostgreSQL now doubles storage to 6 TB and uses gp2 which provides 3 IOPS per GB, letting larger volumes raise baseline IOPS; encryption at rest is supported at storage layer and shows 5–10% write overhead in pgbench write tests while reads are unaffected. Snapshots can be shared unencrypted, major upgrades run via pg_upgrade with pre/post backups, DMS uses logical decoding (requires 9.4+) for near‑zero‑downtime migration, and multi‑AZ failover completes in about 65 seconds.
AI-written summary · about
chapters (29)
- 0:00Intro
- 0:41What's new in storage
- 2:26Encryption at rest overhead
- 3:44Unencrypted Snapshot Sharing
- 5:02Major version upgrade
- 6:50RDS Version updates
- 7:23Additional Logging
- 7:57RDS autovacuum logging
- 8:52pgstattuple
- 9:54rds_superuser_reserved_connections
- 11:29pg_buffercache
- 12:33Operating System (OS) metrics
- 14:26Keep your apps running during the migration
- 15:59AWS Database Migration Service - PostgreSQL
- 16:40Loading data
- 20:37shared_buffers parameter
- 22:14pgbench write workload on r3.8xlarge working set = 10% of memory
- 23:59Availability - Read and Write - Multi-AZ
- 26:11Read Replicas = Availability
- 27:37Read Replica promotion
- 28:19Read Replicas = Scale
- 29:57Replication parameters - continued
- 31:12vacuum_defer_cleanup_age
- 32:06max_standby_archive/streaming_delay
- 33:37hot_standby_feedback
- 36:11Burst mode: GP2 and T2
- 37:10T2 - CPU credits
- 37:49Burst mode: what's new
- 38:29Burst mode vs. Classic vs. Provisioned IOPS
