3 ms·
I'm curious to hear why and how Maria failed you. For a reddit-like social site, we have a Maria database with around 3 billion rows in total, with the largest
by phoboslab 7y ago
I'm curious to hear why and how Maria failed you.
For a reddit-like social site, we have a Maria database with around 3 billion rows in total, with the largest table (votes) spanning about 1,5 billion rows.
We can select data within ~3ms for about 20k-40k concurrent visitors on the site. Our setup is a simple Master-Slave config, with the slave only as backup (not used for selects in production). Our 2 DB servers have 128gb of RAM and cost around 200 EUR/month each - so, nothing special.
Of course you have to design your schema with great care to get to this point, but I imagine PG to be as lost as any other database if a crucial index is missing.