3 ms·

Pretty far!

• 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 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.
  • bpicolo 5y 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/ 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