Machine details
CPU 4 core
OS suse linux 11.2
RAM 24GB
Scale factor 75 shared buffers 4GB
auto vacuum on wal_buffers 16MB
ckpt seg 256 ckpt interval 25min
server_encoding SQL_ASCII client_encoding UTF8
lc_collate C lc_ctype C
sync commit on Fill factor 80
Run time 300 sec
Pgbench - org
CONFIGURATION
Clients 1 2
FPW COMPRESS 
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 130 0.04 163 0.05
Run2 131 0.04 163 0.05
Run3 134 0.04 163 0.05
Avg 131.6666667 0.04 163 0.05
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 134 0.23 161 0.28
Run2 149 0.26 160 0.27
Run3 132 0.23 161 0.28
Avg 138.3333333 0.24 160.6666667 0.28
DIFF
-4.82% -83.33% 1.45% -81.93%
Scale factor 30 shared buffers 4GB
auto vacuum on wal_buffers 16MB
ckpt seg 256 ckpt interval 25min
server_encoding SQL_ASCII client_encoding UTF8
lc_collate C lc_ctype C
sync commit on Fill factor 80
Run time 300 sec
Pgbench - 1000
CONFIGURATION
Clients 1 2
FPW COMPRESS 
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 128 0.02 163 0.04
Run2 132 0.03 162 0.04
Run3 126 0.03 163 0.05
Avg 128.6666667 0.03 162.6666667 0.04
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 143 0.29 161 0.33
Run2 131 0.27 160 0.33
Run3 147 0.30 159 0.33
Avg 140.3333333 0.29 160 0.33
DIFF
-8.31% -90.70% 1.67% -86.87%
Scale factor 75 shared buffers 4GB
auto vacuum on wal_buffers 16MB
ckpt seg 256 ckpt interval 25min
server_encoding SQL_ASCII client_encoding UTF8
lc_collate C lc_ctype C
sync commit on Fill factor 80
Run time 900 sec
Pgbench - org
CONFIGURATION
Clients 1 2
FPW COMPRESS 
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 138 0.11 162 0.14
Run2 135 0.12 163 0.14
Run3 136 0.12 162 0.14
Avg 136.3333333 0.12 162.3333333 0.14
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 144 0.60 160 0.65
Run2 141 0.59 161 0.65
Run3 139 0.59 161 0.65
Avg 141.3333333 0.59 160.6666667 0.65
DIFF
-3.54% -80.34% 1.04% -78.46%
Scale factor 30 shared buffers 4GB
auto vacuum on wal_buffers 16MB
ckpt seg 256 ckpt interval 25min
server_encoding SQL_ASCII client_encoding UTF8
lc_collate C lc_ctype C
sync commit on Fill factor 80
Run time 900 sec
Pgbench - 1000
CONFIGURATION
Clients 1 2
FPW COMPRESS 
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 137 0.09 162 0.17
Run2 133 0.11 162 0.18
Run3 134 0.13 162 0.19
Avg 134.6666667 0.11 162 0.18
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 137 0.80 160 0.92
Run2 137 0.80 160 0.92
Run3 142 0.83 159 0.91
Avg 138.6666667 0.81 159.6666667 0.92
DIFF
-2.88% -86.42% 1.46% -80.36%