The fact that you can just pay to scale out point reads is not news to anyone.
AdamProut•5m ago
yeah, this is a definitely a "best case" workload for a sharded database. Single row reads on the key used to shard with no hotspots (no shard to shard network traffic at all).
samlambert•27m ago
It cost $250,000 to do this run but it feels worth it.
handfuloflight•24m ago
I did not know men could build such things.
whalesalad•16m ago
I estimated the cluster to achieve this was ~$3-4k per-hour. I am thinking there is a typo on the r8g.16xlarge and they are actually r8gd.16xlarge (notice the d) which comes with directly attached nvme disks.
svuiv•4m ago
We used r8g.16xlarge instances with EBS disks, no nvmes
znpy•22m ago
If this is closed source then i have zero interest in it.
AdamProut•4m ago
I'm curious why the test needed so many router hosts:
512 shards, each with one Postgres primary each on an r8g.16xlarge
480 Neki routers, each on its own 8xlarge instance
That's ~250K queries/sec per router which seems lowish?
jeffbee•37m ago
AdamProut•5m ago