3 ms·
I used to effectively do this in postgres with rsync on a known fixture snapshot of the data files. It would usually take under two seconds to reset the state a
by pydry 5y ago
I used to effectively do this in postgres with rsync on a known fixture snapshot of the data files. It would usually take under two seconds to reset the state and restart the servers, which was easily fast enough to do effective TDD.
I had a few other ideas to speed it up, also.
- jpitz 5y agoThere's also creating a template database that exists at a known good state, and using that database template to CREATE DATABASE from. https://www.postgresql.org/docs/current/manage-ag-templatedbs.html https://www.postgresql.org/docs/current/manage-ag-templatedb...