
Machine details							Base records	1000000	fill factor	100
CPU	8 core						update	3	shared buffers	2GB
OS	suse linux 10.3						record size	1800	update size	250
RAM	24GB						threads	8	clients	16
							auto vacuum	off	wal page size	1K
							ckpt seg	256	ckpt interval	15min
							sync commit	off
50 rec modified

fill factor	100

pgbench	old code		Modified code		Difference(%)		LZ code		Difference(%)
pgbench	TPS	Total	TPS	Total	TPS	Total	TPS	Total	TPS	Total
Run1	1522	918988	2699	1623935	77.33246	76.70905	2552	1534038	67.67411301	66.92688
Run2	1496	902229	2501	1501300	67.17914	66.399	2553	1534329	70.65508021	70.05982
Run3	1530	920689	2916	1750731	90.58824	90.15444	2561	1537745	67.38562092	67.02111
Avg	1516	913968.7	2705.333	1625322	78.36661	77.75416	2555.333333	1535371	68.57160471	68.0026



fill factor	80

pgbench	old code		Modified code		Difference(%)		LZ code		Difference(%)
pgbench	TPS	Total	TPS	Total	TPS	Total	TPS	Total	TPS	Total
Run1	1405	843755	3009	1808003	114.1637	114.2806	2939	1764813	109.1814947	109.1618
Run2	1438	863822	3044	1832320	111.6829	112.1178	2704	1632143	88.03894298	88.94437
Run3	1336	804222	3078	1850127	130.3892	130.0518	2902	1747072	117.2155689	117.2375
Avg	1393	837266.3	3043.667	1830150	118.7453	118.8167	2848.333333	1714676	104.8120022	105.1146





100 rec modified

fill factor	100

pgbench	old code		Modified code		Difference(%)		LZ code		Difference(%)
pgbench	TPS	Total	TPS	Total	TPS	Total	TPS	Total	TPS	Total
Run1	1507	911814	2463	1482359	63.43729	62.57252	2317	1394032	53.74917054	52.88557
Run2	1372	825130	2362	1418223	72.15743	71.87873	2757	1655922	100.9475219	100.6862
Run3	1491	895871	2793	1685273	87.32394	88.11559	2416	1450910	62.03890007	61.95524
Avg	1456.666667	877605	2539.333	1528618	74.30622	74.18895	2496.666667	1500288	72.24519749	71.84233