Hacker News new | ask | show | jobs
by stansler 2167 days ago
Another approach is to use thin clones of Postgres to create disposable databases for fast iterations.

We've made Database Lab tool working on top of CoW file systems (ZFS, LVM) that is capable of provision multiterabyte Postgres instances in seconds. The goal is to use such clones to verify database migrations and optimize SQL queries against production-size data. See our repo: https://gitlab.com/postgres-ai/database-lab.