News for hackers. Stuff that matters.
Re:Optimizing Postgres queries at scale by capableweb on Tuesday December 28, 2021 @05:27PM (#29719051)
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.
Re:Optimizing Postgres queries at scale by samokhvalov on Tuesday December 28, 2021 @06:37PM (#29719686)
But 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.