Machine details
CPU 4 core
OS suse linux 11.2
RAM 24GB
Scale factor 75 shared buffers 4GB
auto vacuum off wal_buffers 16MB
ckpt seg 256 ckpt interval 15min
server_encoding SQL_ASCII client_encoding UTF8
lc_collate C lc_ctype C
sync commit off Fill factor 80
Pgbench - org
CONFIGURATION
Clients 1 2 4
WAL LZ code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 1596 1.43 3027 1.82 6144 2.65
Run2 1597 1.43 3057 1.83 6025 2.64
Run3 1599 1.43 3054 1.83 6132 2.65
Avg 1597.333333 1.43 3046 1.83 6100.333 2.65
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 1606 1.48 3099 1.93 6066 2.85
Run2 1606 1.48 3052 1.93 6110 2.85
Run3 1604 1.47 3074 1.93 6002 2.85
Avg 1605.333333 1.48 3075 1.93 6059.333 2.85
DIFF
-0.50% -3.16% -0.94% -5.35% 0.68% -7.13%
Pgbench - 250
CONFIGURATION
Clients 1 2 4
WAL LZ code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 1592 2.43 3059 2.95 6097 3.78
Run2 1591 2.43 3053 2.95 6101 3.78
Run3 1588 2.43 3081 2.95 6003 3.77
Avg 1590.333333 2.43 3064.333333 2.95 6067 3.78
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 1592 2.56 3039 3.24 5745 5.84
Run2 1595 2.56 3061 3.24 5700 5.81
Run3 1591 2.56 3074 3.24 5752 5.84
Avg 1592.666667 2.56 3058 3.24 5732.333 5.83
DIFF
-0.15% -5.08% 0.21% -8.95% 5.84% -35.22%
Pgbench - 500
CONFIGURATION
Clients 1 2 4
WAL LZ code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 1566 3.60 2255 4.96 2527 5.66
Run2 1561 3.59 2245 4.95 2554 5.79
Run3 1564 3.60 2227 4.93 2540 5.73
Avg 1563.666667 3.60 2242.333333 4.95 2540.333 5.73
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 1569 3.80 2050 5.23 2540 6.46
Run2 1567 3.80 1976 4.94 2408 6.12
Run3 1568 3.80 2011 5.11 2489 6.34
Avg 1568 3.80 2012.333333 5.09 2479 6.31
DIFF
-0.28% -5.35% 11.43% -2.88% 2.47% -9.20%
Machine details
CPU 4 core
OS suse linux 11.2
RAM 24GB
Scale factor 30 shared buffers 4GB
auto vacuum off wal_buffers 16MB
ckpt seg 256 ckpt interval 15min
server_encoding SQL_ASCII client_encoding UTF8
lc_collate C lc_ctype C
sync commit off Fill factor 80
Pgbench - 1000
CONFIGURATION
Clients 1 2 4
WAL LZ code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 1483 3.23 2776 4.52 4952 7.34
Run2 1478 3.23 2722 4.27 5299 7.50
Run3 1483 3.23 2840 4.53 5073 7.40
Avg 1481.333333 3.23 2779.333333 4.44 5108 7.41
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 1486 3.66 2415 6.14 4023 9.75
Run2 1484 3.66 2359 6.02 4055 9.82
Run3 1480 3.65 2346 6.02 3999 9.74
Avg 1483.333333 3.66 2373.333333 6.06 4025.667 9.77
DIFF
-0.13% -11.67% 17.11% -26.73% 26.89% -24.12%