Configuration Used | ||||||||
O/S | Suse-11 | |||||||
RAM | 128GB | |||||||
Number of | 16 | |||||||
Server Conf: checkpoint_segments - 300, checkpoint_timeout = 15 min, checkpoint_completion_target=0.9 synchronous_commit=off, AutoVacuum=off | ||||||||
shared_bu | 32GB | |||||||
pgbench | select-only | |||||||
pgbench- | 6700 | |||||||
HEAD | ||||||||
Runs/Concurrency | 16C-16T | 32C-32T | 64C-64T | |||||
Run-1 | 5354 | 4485 | 3607 | |||||
Run-2 | 4672 | 4376 | 3461 | |||||
Run-3 | 3147 | 3052 | 3325 | |||||
Average | 4391 | 3971 | 3464 | |||||
After Patch | ||||||||
Runs/Concurrency | 16C-16T | 32C-32T | 64C-64T | |||||
Run-1 | 5376 | 4449 | 3606 | |||||
Run-2 | 5227 | 4521 | 3474 | |||||
Run-3 | 7838 | 6310 | 4753 | |||||
Average | 6147 | 5093 | 3944 | |||||
Diff In % | 39.99 | 28.25 | 13.85 | |||||
Configuration Used | ||||||||
O/S | Suse-11 | |||||||
RAM | 24GB | |||||||
Number of | 8 | |||||||
Server Conf: checkpoint_segments - 256, checkpoint_timeout = 25 min, synchronous_commit=off | ||||||||
shared_bu | 5GB | |||||||
pgbench | select-only | |||||||
pgbench- | 1200 | |||||||
HEAD | ||||||||
Runs/Concurrency | 8C-8T | 16C-16T | 32C-32T | 64C-64T | 128C-128T | 256C-256T | ||
Run-1 | 59034 | 56109 | 15374 | 7220 | 4441 | 3110 | ||
Run-2 | 58604 | 57056 | 17698 | 5067 | 2621 | 1730 | ||
Run-3 | 58874 | 57057 | 25098 | 4756 | 2511 | 1640 | ||
Average | 58837 | 56740 | 19390 | 5681 | 3191 | 2160 | ||
After Patch | ||||||||
Runs/Concurrency | 8C-8T | 16C-16T | 32C-32T | 64C-64T | 128C-128T | 256C-256T | ||
Run-1 | 59285 | 55970 | 20894 | 9263 | 5655 | 3665 | ||
Run-2 | 59521 | 57246 | 23380 | 6841 | 3770 | 2351 | ||
Run-3 | 59642 | 57592 | 30937 | 6863 | 3074 | 2097 | ||
Average | 59482 | 56936 | 25070 | 7655 | 4166 | 2704 | ||
Diff In % | 1.09 | 0.35 | 29.29 | 34.74 | 30.55 | 25.18 |