Hacker News new | ask | show | jobs
by zie 1535 days ago
Pretty far!
1 comments
endisneigh 1535 days ago
How far was exactly? Like tps for reads and writes with what specs?

I’ve been looking for real world performance.

link
bpicolo 1534 days ago
50k-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/. 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

link
zie 1535 days ago
That'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.

link