4 ms·
How far was exactly? Like tps for reads and writes with what specs? I’ve been looking for real world performance.
by endisneigh 5y ago
How far was exactly? Like tps for reads and writes with what specs?
I’ve been looking for real world performance.
- zie 5y agoThat's complicated based on workload, etc. A single PG node will obviously never scale to Google or Facebook levels. Attend a PG conference and you will run into plenty of people running PG with similar use cases(and maybe similar loads) to you. I can say we run a few hundred concurrent users backed by PG on a small to medium sized VPS without issues. Our DB is in the 3 digit GB range on disk, but not yet TB range.
- bpicolo 5y ago50k-100k reads per second was pretty doable on mysql even back in 2014-2015 era. You can get a 60TB NVMe instance with 96 cores these days - https://aws.amazon.com/ec2/instance-types/i3en/ https://aws.amazon.com/ec2/instance-types/i3en/. Relational databases just scream on the dang things. > 2 million random IOPS at 4 KB block sizes and up to 16 GB/s of sequential disk throughput