| 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 | |||||||||
| pgbench | select-only | |||||||||
| pgbench-Scale Factor | 1200 | |||||||||
| HEAD | ||||||||||
| Runs/Concurrency | 8C-8T | 16C-16T | 32C-32T | 64C-64T | ||||||
| Run-1 | 9664 | 7425 | 5106 | 2570 | ||||||
| Run-2 | 13081 | 9009 | 4874 | 2713 | ||||||
| Run-3 | 13246 | 8932 | 4988 | 2990 | ||||||
| Average | 11997 | 8455 | 4989 | 2757 | ||||||
| After Patch | ||||||||||
| Runs/Concurrency | 8C-8T | 16C-16T | 32C-32T | 64C-64T | ||||||
| Run-1 | 16239 | 11539 | 7395 | 2512 | ||||||
| Run-2 | 21408 | 15090 | 8923 | 2870 | ||||||
| Run-3 | 21776 | 13261 | 8846 | 3083 | ||||||
| Average | 19807 | 13296 | 8388 | 2821 | ||||||
| Diff In % | 65.09 | 57.25 | 68.12 | 2.3 | ||||||