Experiments with Postgres in Docker and the Cloud

on YouTube ↗56m

" summary

Examines running PostgreSQL in Docker containers and in cloud managed services, comparing technologies like AWS RDS, Google Cloud SQL, and Kubernetes operators for Postgres/MySQL. Describes how routine DBA tasks (instance provisioning, backups, replication management, failover) are becoming automated via managed DBaaS and internal RDS-like solutions, and discusses related tooling and operational experience.

AI-written summary · about

" chapters (11)

1. 0:00Introduction
2. 3:20Performance analysis problems
3. 8:18Four optimization methods
4. 12:54Experiments vs manual testing
5. 16:51Nancy tool demo
6. 21:26How Nancy works and features
7. 27:56Load collection challenges
8. 34:20Successful experiment examples
9. 39:37Experiment resources
10. 45:20Future of database experiments
11. 51:01Q&A

" related talks

• 35mContainerizing PostgreSQL and Making it Cloud Native ReadyJeff McCormick · CloudNativeDay 2016
• 51mPostgreSQL in the Cloud: DBaaS vs KubernetesMichal Nosek · Percona Live 2022
• 20mNavigate Postgres Cloud Paths: Kubernetes, IaaS, or DbaaSMarc Linster · PGConf NYC 2021
• 30mBridging the DevOps to Data Divide with a Common Cloud Native StackMey Beisaron, Elad Hirsch · Data on Kubernetes Day NA 2024
• 38mDocker and DatabasesAndrew Pruski · ContainerDays Conference 2024
• 54mPostgres: From Cloud to Hybrid and On Prem AgainGabriele Bartolini · PostgreSQL Conference Europe 2024
• 48mPostgres and Kubernetes: Past, Present and FutureGabriele Bartolini · Kubernetes Community Days Italy 2023
• 43mPostgreSQL in the cloud: Theory and PracticeJohn Melesky · Postgres Open 2012