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

(postgres.saneengineer.com)

52 points | by anivan_ 5 hours ago ago

6 comments

  • nijave 3 minutes ago

    Would be interesting to see huge pages and io2 impact.

    I did a smaller version on Azure and disk latency had a massive impact much more so than max IOPs (although their crappy storage offering needed like 64-128 iodepth to get advertised iops).

    Results seem mostly in line with expectations. Iirc vcpu is threads so on arm64 you get 4 smt1 cores vs Intel/AMD you get 2 smt2 cores.

  • crudgen 2 minutes ago

    Interesting, is there something like this for azure

  • ballislife30 an hour ago

    Would love to see a comparison between Aurora PostgreSQL and self-host PostgreSQL on the same EC2 instance type.

    • anivan_ an hour ago

      Good point! I kept the configuration of the Postgres pretty close to the defaults, and it would be interesting to compare it with the same default Aurora Postgres.

      And it should be easy to add - I'll check it, thanks!

      • toredash 32 minutes ago

        I would really see this compared to what AWS is offering via RDS

        • anivan_ 25 minutes ago

          Yes! This was my initial dilemma - whether to test RDS or self-hosted Postgres on EC2. I decided to start with EC2 to be a bit more "pure", and remove cost overhead of RDS.

          But support for RDS is my next candidate for development. Plus, comparison would also be interesting.