Machine details Base records 1000000 record size 1800
CPU 8 core update 3 shared buffers 2GB
OS suse linux 10.3 auto vacuum off    
RAM 24GB ckpt seg 256 ckpt interval 15min
CONFIGURATION
sync_commit off off off off off off on on on on on on
thread 8 8 1 1 2 2 8 8 1 1 2 2
fill factor 100 80 100 80 100 80 100 80 100 80 100 80
rec length 50
WAL LZ compression for UPDATE + XLOG scale code
  TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS
Run1 2878 2827 1057 1140 1833 1818 420 430 137 141 152 167
Run2 2599 2798 1050 1026 1948 1738 411 434 135 137 154 156
Run3 2646 2759 1030 1016 1753 1718 413 435 138 137 154 158
Avg 2707.666667 2794.667 1045.667 1060.667 1844.667 1758 414.6666667 433 136.6666667 138.3333 153.3333 160.3333
XLOG Scale code
  TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS
Run1 1079 1580 1042 1111 1515 1497 428 434 142 146 150 155
Run2 1340 1659 1045 1083 1384 1532 416 440 148 145 153 155
Run3 1492 1600 1028 1108 1458 1379 415 432 146 147 153 154
Avg 1303.666667 1613 1038.333 1100.667 1452.333 1469.333 419.6666667 435.3333 145.3333333 146 152 154.6667
DIFF
107.70% 73.26% 0.71% -3.63% 27.01% 19.65% -1.19% -0.54% -5.96% -5.25% 0.88% 3.66%
CONFIGURATION
sync_commit off off off off off off on on on on on on
thread 8 8 1 1 2 2 8 8 1 1 2 2
fill factor 100 80 100 80 100 80 100 80 100 80 100 80
rec length 250
WAL LZ compression for UPDATE + XLOG scale code
  TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS
Run1 2432 2455 651 634 1189 1257 414 443 127 129 151 155
Run2 2319 2541 648 648 1247 1246 412 431 129 131 153 155
Run3 2332 2498 683 708 1228 1193 412 438 128 129 182 156
Avg 2361 2498 660.6667 663.3333 1221.333 1232 412.6666667 437.3333 128 129.6667 162 155.3333
XLOG Scale code
  TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS
Run1 1482 1471 729 754 1014 1098 422 431 133 136 151 154
Run2 1523 1532 747 775 1063 1113 419 443 134 137 152 171
Run3 1372 1609 729 753 1021 1086 410 441 134 134 161 154
Avg 1459 1537.333 735 760.6667 1032.667 1099 417 438.3333 133.6666667 135.6667 154.6667 159.6667
DIFF
61.82% 62.49% -10.11% -12.80% 18.27% 12.10% -1.04% -0.23% -4.24% -4.42% 4.74% -2.71%
CONFIGURATION
sync_commit off off off off off off on on on on on on
thread 8 8 1 1 2 2 8 8 1 1 2 2
fill factor 100 80 100 80 100 80 100 80 100 80 100 80
rec length 500
WAL LZ compression for UPDATE + XLOG scale code
  TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS
Run1 2362 2457 670 646 1174 1299 413 428 130 130 153 151
Run2 2387 2614 658 651 1224 1254 415 426 128 131 154 155
Run3 2276 2510 727 649 1268 1208 410 433 129 128 153 170
Avg 2341.666667 2527 685 648.6667 1222 1253.667 412.6666667 429 129 129.6667 153.3333 158.6667
XLOG Scale code
  TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS
Run1 1512 1499 728 789 1040 1138 424 431 130 135 151 154
Run2 1534 1498 746 773 1074 1098 419 430 132 134 152 180
Run3 1526 1530 739 821 1037 1116 411 427 136 134 153 154
Avg 1524 1509 737.6667 794.3333 1050.333 1117.333 418 429.3333 132.6666667 134.3333 152 162.6667
DIFF
53.65% 67.46% -7.14% -18.34% 16.34% 12.20% -1.28% -0.08% -2.76% -3.47% 0.88% -2.46%