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 off Fill factor 80
Run time 300 sec
Pgbench - org
CONFIGURATION
Clients 1 2
FPW COMPRESS 
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 783 0.18 1831 0.39
Run2 825 0.20 1835 0.40
Run3 838 0.21 1865 0.40
Avg 815.3333333 0.20 1843.666667 0.40
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 1000 0.95 2093 1.24
Run2 1008 0.96 2096 1.24
Run3 1026 0.97 2060 1.24
Avg 1011.333333 0.96 2083 1.24
DIFF
-19.38% -79.51% -11.49% -68.01%
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 off Fill factor 80
Run time 300 sec
Pgbench - 1000
CONFIGURATION
Clients 1 2
FPW COMPRESS 
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 741 0.17 1643 0.68
Run2 775 0.25 1681 0.75
Run3 820 0.31 1653 0.76
Avg 778.6666667 0.24 1659 0.73
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 903 1.57 1915 2.78
Run2 983 1.70 1921 2.78
Run3 990 1.71 1975 2.84
Avg 958.6666667 1.66 1937 2.80
DIFF
-18.78% -85.34% -14.35% -73.93%
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 off Fill factor 80
Run time 900 sec
Pgbench - org
CONFIGURATION
Clients 1 2
FPW COMPRESS 
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 935 0.52 2038 1.08
Run2 1009 0.58 2027 1.09
Run3 1005 0.59 2011 1.09
Avg 983 0.56 2025.333333 1.09
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 1029 1.41 2100 1.93
Run2 1084 1.44 2091 1.93
Run3 1082 1.44 2091 1.93
Avg 1065 1.43 2094 1.93
DIFF
-7.70% -60.61% -3.28% -43.70%
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 off Fill factor 80
Run time 900 sec
Pgbench - 1000
CONFIGURATION
Clients 1 2
FPW COMPRESS 
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 858 0.77 1917 2.50
Run2 916 1.15 1883 2.47
Run3 920 1.23 1926 2.51
Avg 898 1.05 1908.666667 2.49
Head code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 989 3.62 1352 5.13
Run2 1028 3.72 1377 5.34
Run3 1045 3.76 1420 5.47
Avg 1020.666667 3.70 1383 5.31
DIFF
-12.02% -71.62% 38.01% -53.07%