4 ms·
> How else do you test and optimize SQL queries that are only slow with production-size data? With something like this https://www.getsynth.com/docs/blog/2021/
by nextaccountic 5y ago
> How else do you test and optimize SQL queries that are only slow with production-size data?
With something like this https://www.getsynth.com/docs/blog/2021/03/09/postgres-data-gen https://www.getsynth.com/docs/blog/2021/03/09/postgres-data-... (disclaimer: no affiliation with them, I've not used their product but it appears to be fully open source)
- akartasov 5y agoI agree that this is a possible way. The main difficulty of the generated data is related to their quality and structure. Namely, how artificial data correspond (quantitatively and qualitatively) to real data. Random data may give incorrect results when optimizing a query.
- nextaccountic 5y agoYep! The idea of that is to generate data that isn't just random but has the right structure. But, I don't know if they deliver.