3 ms·
Yeah, if your database is under 1TB, it's relatively easy and usable to just clone the full thing. But above that, it starts becoming a hassle and you might nee
by capableweb 5y ago
Yeah, if your database is under 1TB, it's relatively easy and usable to just clone the full thing. But above that, it starts becoming a hassle and you might need to strip away some stuff you don't care about (and won't affect the query plans), otherwise it can take a long time to backup/restore into new instance.
- samokhvalov 5y agoBut in general case, such clones are not suitable for query optimization tasks. And as I already mentioned in my other comments here, thin cloning is a great way to solve the speed (and money) problem for larger DBs.