Show HN: PostgreSQL performance and cost across 23 EC2 instance types

·Hacker News··

Hey! I'm Andrei.I got frustrated by how people tend to build overcomplicated backend systems, being "motivated" by big tech case studies and popular books.So, I started exploring lean architecture, and building my digital garden of ideas, approaches and data that align with this direction.Here I want to present one of the tools – Sizing tool for PostgreSQL. I've benchmarked PostgreSQL on different EC2 instances and disks, with different initial data sets to see performance that these instances can give you. And I've built a tool to visualize this data, which I welcome you to explore.So, you can put your usual input parameters, like needed RPS and disk size as input, and find out which instance will be the most cost-efficient for your needs.You can read about the methodology here: https://postgres.saneengineer.com/aboutI've tested one workload – mixed 90/10 read/write, and only selected configurations. But it is extensible, and I (and you – benchmark is open source: https://github.com/anivaniuk/sanebench) can run more configurations to have more data represented.Does it look interesting? What workload should I benchmark next?

Read full article →

Related Articles

Malicious Rust crate Arrayref runs a build-time payload
abhisek · Hacker News · 1d ago
Japan tried to build an operating system for the world, the US intervened
rdmuser · Hacker News · 13h ago
Kobo can run apps now
thepoet · Hacker News · 2h ago
Cancer-related mortality among US pilots and flight attendants
jader201 · Hacker News · 3h ago
AliExpress runs silent WebAudio fingerprinting that breaks Bluetooth multipoint
emctech · Hacker News · 1d ago