PostgreSQL at Amazon

on YouTube ↗19m

" summary

Amazon moves from Oracle to PostgreSQL at massive scale: migrated 7,500 Oracle databases and 75 PB of data into Postgres variants, drove Redshift (initially 1.6 PB MPP) and launched RDS and Aurora with separated compute/storage. RDS ships community releases day‑one and now supports 92 extensions; instance sizes reach 196 vCPUs/4 TB RAM and AWS previews U7 with 1,920 vCPUs/32 TB. Upstream contributions target Postgres 17/18 features like B‑tree IN optimizations, built‑in collations, parallelized major upgrades and stats export/import, plus Aurora DSQL and automatic sharding.

AI-written summary · about

" chapters (15)

1. 0:00Amazon’s PostgreSQL vision
2. 1:27AWS launches managed PostgreSQL
3. 3:55Aurora’s compute-storage split
4. 5:02Oracle to PostgreSQL migration
5. 6:49PostgreSQL in daily ops
6. 7:55Scaling PostgreSQL to exabytes
7. 8:57AWS extension plans
8. 10:23Aurora’s automatic sharding
9. 11:45Amazon’s PostgreSQL team
10. 13:09PostgreSQL 17 optimizations
11. 14:37Always-available PostgreSQL focus
12. 15:40Reducing PostgreSQL downtime
13. 16:43Next-gen hardware for PostgreSQL
14. 17:30PostgreSQL for GenAI challenges
15. 18:32Multi-region PostgreSQL solutions

" related talks

• 18mPostgreSQL at AmazonJim Mlodgenski · PGConf India 2025
• 39mAWS AuroraBlair Layton · FOSSASIA Summit 2017
• 10mPostgres on AWS: Run 5X faster on metal, migrate anywhereOzgun Erdogan · PostgreSQL Conference Europe 2025
• 40mPushing past PostgreSQL’s vertical scaling limits - Running Amazon RDSAlisdair Owens, Andrei Dukhounik · PGConf.dev 2024
• 53mPostgres in Amazon RDSDenish Patel · PostgresOpen 2014
• 14mBuilding a better PostgreSQL togetherJonathan S. Katz · PGConf NYC 2022
• 47mPostgres & BeyondWei Hong, Margo Seltzer, Joe Hellerstein, Anant Jhingran, Mike Olson · A Celebration of Mike Stonebraker (April 12, 2014)
• 41mRunning Highly Available Postgres in AWS RDSSushant Mahesh Pawar · FOSSASIA Summit 2017