Lightning-Fast Database Tests
summary
Library called PG test DB uses template databases to spin up isolated ephemeral Postgres instances for each test, integrating with pgx and migration tools like golang-migrate. Template build time is about 0.5s and cloning a new database is ~10 ms, enabling parallel tests and avoiding teardown. Benchmarking shows a best-case ~5× speedup when combined with tmpfs and fsync disabled; failed tests preserve their databases for inspection while successful ones are deleted.
AI-written summary · about
related talks
56mLightning Talks
36mAutomated Performance Testing of Postgres
17mA Laboratory for Databases
38mPerforming Databases Migrations Without Overtime
47mA Journey to Postgres Productivity with Go
44mContinuous Database Administration
43mPostgreSQL in the cloud: Theory and Practice
44mEfficiently Deploying PostgreSQL Instances: The Evolution