anivan_

4 ms·

1.
by anivan_ 2mo ago
That might be an interesting comparison :) Especially, cost-efficiency. I'll think how to put it, thanks :)
2.
by anivan_ 2mo ago
I think we have a lot of DBs specialised for heavy write, like anything with LSM-tree in their base. My vision is that there will be more movement in this direction, but still, we need first to understand limits of "easy to work with&q
3.
by anivan_ 2mo ago
It's requests per second, and I briefly described that on https://postgres.saneengineer.com/about Small badges will be helpful, though. I added hovers in some places, like for latency numbers, but I think more visible
4.
by anivan_ 2mo ago
Yeah, good point - I've limited the scope to make the first release more lightweight. I'll add them in the next one, thanks!
5.
by anivan_ 2mo ago
Yes, I want to cover RDS with all of its specifics as the next step. Thanks for highlighting this!
6.
by anivan_ 2mo ago
Good points, thanks. On huge pages: this is also about RDS vs self-managed EC2 Postgres. RDS effectively has "on" by default, but default self-managed (that I benchmarked) is "try" which is effectively "off". I
7.
by anivan_ 2mo ago
I was initially inspired by the https://instances.vantage.sh/ , so, like them, I want to add other providers later. Like Azure and GCP. It would also be interesting to have cross-provider comparison. I think it's doable
8.
by anivan_ 2mo 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.
9.
by anivan_ 2mo 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!
10.
Show HN: PostgreSQL performance and cost across 23 EC2 instance types(postgres.saneengineer.com)
97 points by anivan_ 2mo ago|20 comments
11.
by anivan_ 4mo ago
I got frustrated seeing how system design questions differ from the real world, and how big tech companies foster a scalability-first mindset across the industry, while cost-efficiency and critical thinking about real product requirements a
12.
Bitly handles 93 writes/s – URL shortener interviews ask for 1160(saneengineer.com)
3 points by anivan_ 4mo ago|1 comments
13.
by anivan_ 7mo ago
I got frustrated seeing how system design questions differ from the real world, and how big tech companies foster a scalability-first mindset across the industry, while cost-efficiency and critical thinking about real product requirements a
14.
Bitly handles 93 writes/s – URL shortener interviews ask for 1160(saneengineer.com)
3 points by anivan_ 7mo ago|1 comments