托马斯·冯德拉:基准测试很困难,有时……
I do a fair number of benchmarks, not only to validate patches, but also to find interesting (suspicious) stuff to improve. It’s an important part of my development workflow. And it’s fun ;-) But...
基准测试中发现,使用pgbench进行只读操作时,客户端数量增加到22时吞吐量骤降,100个客户端时又恢复。分析排除了锁、CPU资源竞争和NUMA等因素,怀疑与内核任务调度有关。将进程固定到同一核心后,吞吐量显著提升,表明任务调度对性能影响显著。
