3 ms·
Vey interesting but again will the same amount of core and memory result in the same amount of transaction per seconds? How can we easily know what is the opti
by skyde 8y ago
Vey interesting but again will the same amount of core and memory result in the same amount of transaction per seconds?
How can we easily know what is the optimal number of CPU core and Memory needed to achieve X Transaction per seconds ?
I know benefit of memory depend on cache hit rate, or how large is your working set. But assuming 100% cache hit rate how many core do you really need ?
- oskari 8y agoWill the same amount of cores result in the same tps? No. I gave a talk on this subject at PostgresConf NYC a couple weeks ago, my slides are here: https://postgresconf.org/conferences/2019/program/proposals/transactions-per-dollar-postgresql-in-virtual-and-bare-metal-clouds https://postgresconf.org/conferences/2019/program/proposals/... I'll follow up with a blog post in the near future.