Configuration Used | |||||||||||||||||
O/S | Suse-11 | ||||||||||||||||
RAM | 24GB | ||||||||||||||||
Number of Cores | 8 | ||||||||||||||||
Server Conf: checkpoint_segments - 256, checkpoint_timeout = 25 min, synchronous_commit=off | |||||||||||||||||
shared_buffers | 5GB | shared_buffers | 7G | shared_buffer | 10G | ||||||||||||
pgbench | select-only | ||||||||||||||||
pgbench-Scale Factor | 1200 | ||||||||||||||||
Each Run unit | tps | ||||||||||||||||
HEAD | HEAD | HEAD | |||||||||||||||
Runs/Concurrency | 8C-8T | 16C-16T | 32C-32T | 64C-64T | Runs/Concurrency | 8C-8T | 16C-16T | 32C-32T | 64C-64T | Runs/Concurrency | 8C-8T | 16C-16T | 32C-32T | 64C-64T | |||
Run-1 | 9664 | 7425 | 5106 | 2570 | Run-1 | 2026 | 1639 | 1670 | 1711 | Run-1 | 1138 | 2219 | 2194 | 2112 | |||
Run-2 | 13081 | 9009 | 4874 | 2713 | Run-2 | 1631 | 1422 | 1542 | 1543 | Run-2 | 2432 | 2280 | 2139 | 2208 | |||
Run-3 | 13246 | 8932 | 4988 | 2990 | Run-3 | 1560 | 1324 | 1524 | 1573 | Run-3 | 2443 | 2313 | 2254 | 2199 | |||
Average | 11997 | 8455 | 4989 | 2757 | Average | 1739 | 1461 | 1578 | 1609 | Average | 2004 | 2270 | 2195 | 2173 | |||
After Patch | After Patch | After Patch | |||||||||||||||
Runs/Concurrency | 8C-8T | 16C-16T | 32C-32T | 64C-64T | Runs/Concurrency | 8C-8T | 16C-16T | 32C-32T | 64C-64T | Runs/Concurrency | 8C-8T | 16C-16T | 32C-32T | 64C-64T | |||
Run-1 | 16239 | 11539 | 7395 | 2512 | Run-1 | 4039 | 1599 | 1437 | 1424 | Run-1 | 2298 | 2199 | 2062 | 2015 | |||
Run-2 | 21408 | 15090 | 8923 | 2870 | Run-2 | 2824 | 2004 | 1780 | 1685 | Run-2 | 2253 | 2189 | 2159 | 2057 | |||
Run-3 | 21776 | 13261 | 8846 | 3083 | Run-3 | 5224 | 2170 | 2013 | 2011 | Run-3 | 2344 | 2128 | 2114 | 2060 | |||
Average | 19807 | 13296 | 8388 | 2821 | Average | 4029 | 1924 | 1743 | 1706 | Average | 2298 | 2172 | 2111 | 2044 | |||
Diff In % | 65.09 | 57.25 | 68.12 | 2.3 | Diff In % | 131.68 | 31.69 | 10.45 | 6.02 | Diff In % | 14.67 | -4.32 | -3.83 | -5.93 |