2 ms·
Take a look at Database Lab: https://postgres.ai/products/database-migration-testing https://postgres.ai/products/database-migration-testing The idea is to use
by samokhvalov 5y ago
Take a look at Database Lab: https://postgres.ai/products/database-migration-testing https://postgres.ai/products/database-migration-testing
The idea is to use block-level copy-on-write (ZFS by default, LVM2 is an option too, though less powerful) to be able to get thin clones really fast. Currently supports only Postgres. The engine is open source. Result; single machine with Postgres DB of any size, you pay 1x for storage and compute, and can have dozens of independent DBs, provisioning takes a few seconds.
This is used in CI/CD context so getting temporary full-size for any tests is not a problem any more.
We constantly add new features and looking forward to new use cases.
Some case studies with numbers are here: https://postgres.ai/resources https://postgres.ai/resources
Here is how GitLab uses it for DB testing: https://docs.gitlab.com/ee/architecture/blueprints/database_testing/ https://docs.gitlab.com/ee/architecture/blueprints/database_...
(disclaimer: I'm the founder of Postgres.ai, the company that develops Database Lab).