I'd be very curious to see you add the Optimized Reads instance types, e.g. r8gd or m8gd, to your benchmark. They add a local NVMe-based SSD block storage that serves as a cache in front of the network-based disks among other use cases. They have been a huge win for us for a read-heavy workload where the dataset is significantly larger than memory.
Edit: Apologies, on a closer read, I realize you were not testing RDS but managing Postgres on EC2 directly.
Edit: Apologies, on a closer read, I realize you were not testing RDS but managing Postgres on EC2 directly.
[ my public key: https://keybase.io/mateolargo; my proof: https://keybase.io/mateolargo/sigs/ezV7MpDdq7S6s_6glV8gcvTMINrpTfCYIXwBIWpxuNQ ]
YC Badge: 0x0fa3d26951e11fb68e2d93fce3fef214060facc8