PostgreSQL Universe

This is the very video where the benefits of Aurora Postgres were revealed. Many technical details: problem with checkpoints and full-page writes, basic concepts of Aurora architecture, benchmarks. A must-watch.

Aurora Postgres is considered as a replacement for Oracle, so of course, AWS is interested in advertising case studies of the conversion. Good to see more and more companies migrating. However, I feel very sorry to those who use DMS – it's definitely no fun. Allocate a good amount of workforce if you're going to go this route.

Performance Insights, inspired by Oracle tooling, is a must-have thing these days. AWS helped make this approach ("active session history analysis" – in Postgres, it's based on sampling of pg_stat_activity) the 3rd standard way in PostgreSQL query analysis – in addition to pg_stat_statements and log-based analysis. If you're not on RDS/Aurora, this video is still useful – check it out and then also check PASH Viewer https://github.com/dbacvetkov/PASH-Viewer, pg_wait_sampling https://github.com/postgrespro/pg_wait_sampling, and pgsentinel https://github.com/pgsentinel/pgsentinel

Jeremy Scheider has always great materials (unfortunately, not often). If you're on Aurora, this is a must-watch.

Great overview of RDS Postgres capabilities. Video has time codes, convenient.

Jignesh knows a lot about Postgres and RDS – this talk is a good bag of tricks (video has timecodes)