Server benchmarking by Brian Ghidinelli <brian at vfive period com>
	Compaq DL380 G2 with 6 10k RPM 18gb U3 SCSI drives, 16mb Smart Array 5i controller
	2 x 1.44ghz processors (512k cache), 1GB ram
	Postgres v8.1.2 Benchmarking, default postgresql.conf
	Fresh CentOS 4.2 install, all non-critical daemons disabled
	All tests with ext3 (XFS, JFS and Reiser not available in default CentOS)
			Pgbench results, transactions = 500, scaling factor = 10 (tps excluding connections)
			1 user				2 users				5 users				10 users
			r1	r2	r3	avg	r1	r2	r3	avg	r1	r2	r3	avg	r1	r2	r3	avg
OS/Postgresql Settings
3-disk RAID-5 baseline, same spindles
	Default settings, baseline		83.71	76.3	78.87	79.6	67.95	69.89	68.06	68.6	74.21	72.5	75.19	74.0	73.68	73.98	75.52	74.4
	Default settings, postmaster -F		451.85	449.11	441.85	447.6	585.03	577.86	697.71	620.2	580.84	584.5	583.17	582.8	421.44	465.83	392.29	426.5
3-disk RAID-5, all on same spindles
	& noatime,data=writeback		87.97	91.41	91.04	90.1	105.01	105.26	108.33	106.2	152.46	151.74	151.53	151.9	115.73	112.4	112.41	113.5
	& noatime,data=journal		29.03	30.43	30.82	30.1	28.16	27.95	28.22	28.1	32.7	33.14	32.77	32.9	33.34	34.73	34.64	34.2
	not doing since -F is not safe, it's pointless
3-disk RAID-5, xlog on RAID-1 (+OS)
	& noatime		111.75	130.4	120.95	121.0	136.45	104.87	123.72	121.7	125.74	119.04	173.67	139.5	126.7	120.95	126.16	124.6
	& noatime,data=writeback		136.92	138.52	137.27	137.6	148.83	149.91	151.55	150.1	251.53	253.13	248.76	251.1	158.47	161.81	161.17	160.5
	& noatime,data=journal		121.11	131.98	135.07	129.4	132.42	130.53	136.07	133.0	155.54	162.59	162.99	160.4	103.03	101.9	105.23	103.4
2-disk RAID-1, all on same disk
	& noatime		107.66	111.73	124.4	114.6	99.48	99.13	94.76	97.8	110.05	105.28	105.02	106.8	106.92	107.36	106.35	106.9
	& noatime,data=writeback		130.1	124.26	127	127.1	152.43	151.39	152.41	152.1	258.79	258.13	258.61	258.5	190.47	192.32	189.75	190.8
	& noatime,data=journal		39.33	38.82	38.84	39.0	36.65	38.49	38.7	37.9	45.51	46.46	46.34	46.1	47.09	47.5	47.55	47.4
2, 2-disk RAID-1s, xlog separate RAID-1 array
	& noatime		147.18	147.74	138.85	144.6	137.49	147.74	142.74	142.7	179.46	180.46	178.59	179.5	160.25	153.2	156.88	156.8
	& noatime,data=writeback		151.53	135.61	153.152	146.8	153.63	158.83	154.27	155.6	264.3	263.07	154.27	227.2	200.34	195.4	198.89	198.2
	& noatime,data=journal		46.78	46.67	48.07	47.2	51.48	52.04	52.71	52.1	78.69	83.13	77.37	79.7	77.83	79.64	79.78	79.1
	postmaster -F, & noatime,data=writeback		423.52	438.78	439.92	434.1	596.83	580.84	586.79	588.2	537	576.78	577.02	563.6	527.2	458.73	530.02	505.3
4-disk RAID 10, xlog on RAID-1 (OS)
	& noatime,data=writeback		301.06	309.78	301.82	304.2	393.77	386.5	401.11	393.8	394.89	351.02	335.24	360.4	293.38	285.7	378.24	319.1
						1.5%				8.3%				21.0%				20.9%
						6.3%				3.5%				-10.5%				19.0%