Hacker News new | ask | show | jobs
by fragmede 37 days ago
Yeah, but also, I want to know the p50 warm performance, not just the p99. Run the same query twice in a row after cold start. And then another 10 times. Then do another different set of queries and at the end of the day, or a week, still have no real idea how the system will perform in prod for your particular use case.

Benchmarking is hard, no argument from me!

1 comments

Yep, I actually want to know the system has some sort of baseline performance that only hockey sticks under conditions I can monitor and control... but also the business wants to try new feature X and vendor is promising new performance for feature Y, and new patches are coming in affecting ???.
And oh, you just have to set this one setting that you need to pay a consultant to know all the settings in order to tweak and tune the database for your use case. Still the TPC competitions such that oracle won because they managed to hand two assembly from five instructions down to four as an impressive bit of computer engineering nerditry.