| 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% | |||||