A Laboratory for Databases
summary
A platform for PostgreSQL creates isolated production-like clones in seconds using ZFS snapshots plus backup and WAL restore so clones keep physical layout and can roll to any point in time. It spins up large databases (e.g., 4.5 TB) under 30 seconds, preserves production-equivalent metrics, integrates query capture, flamegraphs and EXPLAIN plans, supports plugins, and enables fast experimentation (example: a query improved from 2.5 minutes to 150 ms after applying an index in a clone).
AI-written summary · about
chapters (11)
- 0:00Introduction
- 0:43Test bench problems
- 3:09DTP Snap solution
- 4:17Development use
- 5:23Analytics and migrations
- 6:10Junior developer training
- 7:16Query optimization
- 9:05Cache tuning
- 10:07Query visualization
- 11:16Other uses
- 11:36Q&A
related talks
38mPerforming Databases Migrations Without Overtime
51mPostgreSQL on ZFS
46mTransform your development workflow with thin cloning
44mContinuous Database Administration
06mLightning-Fast Database Tests
46mBig databases, many servers, data center or cloud - it's all here!
44mEfficiently Deploying PostgreSQL Instances: The Evolution
27mBuilding a PostgreSQL data warehouse