Show HN: PostgreSQL performance and cost across 23 EC2 instance types
6 hours ago
- #Performance Benchmark
- #AWS Sizing
- #PostgreSQL
- Choose an AWS instance based on dataset size and throughput needs; select the cheapest option meeting requirements from benchmarked instance-disk combinations.
- The workload for this benchmark is 90% read and 10% write, with a concurrency of 32, using PostgreSQL 17 in the us-east-1 region with on-demand pricing.
- Performance metrics include transactions per second (TPS), latency, and cost per hour; instances like c8i.large and m8g.large offer high TPS at lower costs, while t-series instances are cheaper but less performant.