Efficiently Deploying PostgreSQL Instances: The Evolution

on YouTube ↗44m

" summary

Claims that PostgreSQL instances appear in minutes or seconds and demonstrates the exact commands and tradeoffs: nedbeaver (LXD + Ansible) provisions replication and a three-node Patroni cluster with etcd and can install PMM and pg_stat_monitor, but complex deploys can take five–ten minutes; postgresql sandbox compiles and runs a binary in seconds on mac M1, exposes psql and pgbench, and warns about destroy using rm -rf; Docker examples show basic docker run, docker exec, docker logs and when each tool is appropriate.

AI-written summary · about

" chapters (12)

1. 0:00Start
2. 0:29Agenda
3. 11:12anydbver -- create / use /cleanup
4. 15:30anydbver -- Advanced topologies
5. 19:24anydbver -- list / logs
6. 20:47anydbver -- Advanced usage pt. Il
7. 24:54anydbver -- Anatomy of deploy command
8. 27:09postgresql_sandbox -- install / help
9. 31:20postgresql_sandbox -- Create / use /cleanup
10. 36:38postgresql_sandbox -- Compiling
11. 38:08Docker -- install / help
12. 38:23Docker -- create / use /cleanup

" related talks

• 43mPostgreSQL in the cloud: Theory and PracticeJohn Melesky · Postgres Open 2012
• 36mHighly Available PostgreSQL Database Cluster Creation & Monitoring in Minutesconcerned boy · HashiTalks 2020
• 46mBig databases, many servers, data center or cloud - it's all here!Flavio Gurgel · Devoxx France 2021
• 44mContinuous Database AdministrationNikolay Samokhvalov · Backend Conf 2018
• 36mBest Practices in PostgreSQL Tuning: Navigating Key Performance Bottlenecks in the CloudAlicja Kucharczyk, Dilip Ramachandran · SQLBits 2024
• 36mAutomated Performance Testing of PostgresGreg Burek · PostgresOpen 2014
• 51mWhen Postgres Can't, You Can!Keith Fiske · PostgresOpen 2013
• 38mPerforming Databases Migrations Without OvertimePieter Vincken · JCON Europe 2023