3 ms·
> tested on real-world databases containing 500,000+ tables and 1,000,000+ indexes. Would love to hear about this use case out of curiosity
by matthewaveryusa 7y ago
> tested on real-world databases
containing 500,000+ tables and 1,000,000+ indexes.
Would love to hear about this use case out of curiosity
- KoenDG 7y agohalf a million tables... In how many databases? Spread across how many machines? Using hardware that is how old? It may well be a good project, but statements like that aren't inspiring of confidence.
- samokhvalov 7y agoOne single database. Yes, quite unusual case of multi-tenant database. We needed to use checkup there a while ago so made some optimizations. I agree with you, the statement is not 100% clear. We will double-check it (and maybe will simulate the case in CI), and will improve the statement. Thank you.
- tomnipotent 7y agoI'm guessing those numbers are cumulative across all the databases scanned, not within one.
- samokhvalov 7y agoNo, it was a single real-world database. Just in case if it looks surprisingly that Postgres can deal with such numbers of objects, I suggest checking this out: https://www.pgcon.org/2013/schedule/attachments/283_Billion_Tables_Project-PgCon2013.pdf https://www.pgcon.org/2013/schedule/attachments/283_Billion_...