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 Diff for UPDATE + XLOG scale code
  TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS
Run1 3534 5861 1522 1455 2203 2426 420 429 141 142 153 189
Run2 3471 3366 1480 1519 2434 2507 420 429 146 142 155 156
Run3 3239 3524 1463 1465 2355 2345 415 426 144 142 154 156
Avg 3414.666667 4250.333 1488.333 1479.667 2330.667 2426 418.3333333 428 143.6666667 142 154 167
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
161.93% 163.50% 43.34% 34.43% 60.48% 65.11% -0.32% -1.68% -1.15% -2.74% 1.32% 7.97%
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 Diff for UPDATE + XLOG scale code
  TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS
Run1 2342 2537 787 786 1470 1432 419 430 133 133 163 181
Run2 2656 2566 775 788 1537 1444 415 432 135 132 154 183
Run3 2311 2535 770 788 1406 1453 414 424 128 131 153 154
Avg 2436.333333 2546 777.3333 787.3333 1471 1443 416 428.6667 132 132 156.6667 172.6667
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
66.99% 65.61% 5.76% 3.51% 42.45% 31.30% -0.24% -2.21% -1.25% -2.70% 1.29% 8.14%
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 Diff for UPDATE + XLOG scale code
  TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS TPS
Run1 1971 2392 773 786 1423 1386 420 429 133 133 160 154
Run2 2272 2404 758 787 1396 1517 416 428 135 130 152 154
Run3 2127 2243 769 785 1352 1383 414 439 134 134 153 154
Avg 2123.333333 2346.333 766.6667 786 1390.333 1428.667 416.6666667 432 134 132.3333 155 154
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
39.33% 55.49% 3.93% -1.05% 32.37% 27.86% -0.32% 0.62% 1.01% -1.49% 1.97% -5.33%