Machine details							Base records	1000000	record size	1800
CPU	8 core						update	3	shared buffers	2GB
OS	suse linux 10.3						auto vacuum	off	wal page size	1K
RAM	24GB						ckpt seg	256	ckpt interval	15min
CONFIGURATION
sync_commit	off		off		off		on		on		on
threads	8		1		2		8		1		2
fill factor	100
rec length	50
WAL LZ compression for UPDATE + XLOG scale code
	TPS	Total ops	TPS	Total ops	TPS	Total ops	TPS	Total ops	TPS	Total ops	TPS	Total ops
Run1	2230	1340231	952	571365	1533	920071	286	171804	93	56080	93	56051
Run2	2150	1293425	992	595777	1409	848130	283	169966	93	55964	94	56641
Run3	1868	1123663	962	579157	1470	882440	282	169766	93	55983	94	56670
Avg	2082.666667	1252440	968.6667	582099.7	1470.667	883547	283.6666667	170512	93	56009	93.66667	56454
XLOG Scale code
	TPS	Total ops	TPS	Total ops	TPS	Total ops	TPS	Total ops	TPS	Total ops	TPS	Total ops
Run1	969	582043	1009	605898	1375	825249	284	170928	91	55064	91	54725
Run2	1195	720715	996	598788	1366	823423	281	169541	91	55171	90	54516
Run3	1397	839578	1001	600750	1298	778880	280	169086	92	55246	90	54318
Avg	1187	714112	1002	601812	1346.333	809184	281.6666667	169851.7	91.33333333	55160.33	90.33333	54519.67
DIFF
	75.46%	75.38%	-3.33%	-3.28%	9.23%	9.19%	0.71%	0.39%	1.82%	1.54%	3.69%	3.55%