My laptop running OOTB Postgres in docker does 100k requests per second with ~5ms latency. How are you getting 20x slower?

▲

Koffiepoeder 8 hours ago | parent | next [-]

If you look at their lab [0], it seems his NAS is separate from his kubernetes nodes. If he hasn't tuned his networking and NAS to the maximum, network storage may in fact add a LOT of delay on IOPS. Could be the difference between fractions of a millisecond vs actual milliseconds. If your DB load is mostly random reads this can really harm performance. Just hypothesizing here though, since it is not clear whether his DB storage is actually done on the NAS.

[0]: https://dizzy.zone/2025/03/10/State-of-my-Homelab-2025/

	▲	mj2718 2 hours ago \| parent [-]
		Sorry but if he’s using a setup that’s 20x worse than a regular laptop then I’m not really interested in his setup. To be fair, I asked the question and you found the answer - lol, my bad. Yes I agree using a nas that adds latency would reduce the TPS and explain his results. “Littles law”

▲

nasretdinov 8 hours ago | parent | prev [-]

That's what I'm struggling with too. Redis can also serve roughly 500k-1m QPS using just ~4-8 cores, so on two cores it should be about 100k-200k at least

	▲	mj2718 2 hours ago \| parent [-]
		Yep… this is what I expect as a baseline. This is also why I rarely use redis - Postgres at 100k TPS is perfectly fine for all my use cases, including high usage apps.