5 ms·
My laptop running OOTB Postgres in docker does 100k requests per second with ~5ms latency. How are you getting 20x slower?
by mj2718 1y ago
My laptop running OOTB Postgres in docker does 100k requests per second with ~5ms latency. How are you getting 20x slower?
- nasretdinov 1y agoThat'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 1y agoYep… 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.
- Koffiepoeder 1y agoIf 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/ https://dizzy.zone/2025/03/10/State-of-my-Homelab-2025/
- mj2718 1y agoSorry 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”