pg vs mysql point select pk


1	threads	mysql	postgres	mysqlps	pgps
2	8	34258.32	27447.38	36346.53	35188.44
3	12	49297.04	36274.83	51952.94	49090.72
4	16	62692.15	43166.03	66432.17	58730.85
5	20	81584.23	56191.89	92478.86	65412.86
6	24	106114.16	67100.12	108629.71	78340.43
7	28	124197.32	67909.28	131671.34	93402.14
8	32	133675.84	65979.86	141655.86	97667.66
9	36	144829.84	67519.84	151397.15	99059.89
10	40	155317.55	67493.01	161152.28	97953.5
11	44	161742.28	65568.11	171785.66	96578.2
12	48	165247.95	66006.6	175862.65	92942.65
13	52	167798.39	64162.16	176829.04	93468.78
14	56	168879.88	62898.32	178282.8	95242.17
15	60	168885.14	63754.07	177599.06	91800
16	64	168759.88	63825.02	176720.71	90177.94
17	68	167369.73	64075.48	175449.12	88061.32
18	72	166763.9	62888.14	174577.23	89459.15
19	76	165457.71	62652.58	172979.51	88129.01
20	80	165393.2	62967.37	171157.56	90207.06
21	84	163932.94	60925.1	170083.87	89249.99
22	88	162643.94	62363.78	169834.3	86921.38
23	92	161929.96	61138.52	167494.57	89582.89
24	96	160577.4	61499.02	169546.11	90151.61
25	100	159767.75	60156.22	165639.28	82215.05
26	104	159161.7	60953.19	165051.09	83857.25
27	108	158277.65	60299.02	164647.63	87655.96
28	112	157681.77	60973.28	163309.53	80571.95
29	116	156355.47	58777.7	161669.33	80420.29
30	120	153337.12	58355.06	160007.05	86204.08
31	124	154907.38	59575.41	160089.84	84602.97
32	128	153942.04	57930.21	158716.73	84347.31
33	132	151107.74	58001.16	157540.33	82405.37
34	136	151065.6	58450.79	157251.72	85106.13
35	140	148721.85	56860.45	155762.78	74662.61
36	144	149420.1	57278.83	155204.86	81067.45
37	148	149535.13	57691.22	155152.82	81045.59
38	152	148558.16	55991.93	155315.71	79188.75
39	156	148624.73	56040.98	153058.41	80606.41
40	160	147702.86	57131.41	152092.88	77281.52
41	164	146905.6	54039.96	150959.59	79341.08
42	168	147013.29	55967.89	150032.22	75429.05
43	172	146541.37	54970.07	148779.51	72421.27
44	176	145771.12	53947.66	143806.51	79993.8
45	180	145855.05	54898.44	148097.86	73594
46	184	145620.5	54389.87	147887.91	71026.91
47	188	145481.81	54241.29	148203.94	71098.96
48	192	145018.18	52844.77	148257.61	76486.36
49	196	142751.35	53487.06	146426.77	73169.62
50	200	142855.51	52055.22	146253.36	72723.89
51	204	142859.63	51885.66	145409.37	75499.37
52	208	141901.95	52826.29	144885.64	76769.23
53	212	140151.17	51157.47	145769.89	70725.69
54	216	139676.77	52032.09	144263.34	68038.73
55	220	139284.98	52985.52	140809.58	70464.14
56	224	136585.16	51051	138509.75	72648.72
57	228	131943.79	50236.53	130538.31	71427.78
58	232	129198.85	50240.11	127704.84	66942.22
59	236	124368.72	51184.51	129399.95	68607.79
60	240	123419.38	51157.99	117440.85	66456.57
61	244	116724.78	50352.57	114873.95	66151.92
62	248	114552.46	51420.36	108551.81	69705.8
63	252	106534.54	46450.87	108892.11	71270.35
64	256	106754.52	51403.4	103344.66	69594.94
65	260	99846.8	49274.72	102494.9	64810.44
66	264	97969.98	49819.25	102752.53	64890.4
67	268	97080.65	50055.07	98446.09	64240.93
68	272	95851.38	48561.38	97704.38	69871.54
69	276	93645.9	49087.14	94957.95	68424.55
70	280	93391.44	46140.63	94266.33	63654.3
71	284	90065.82	48549.31	91107.22	63443.57
72	288	86816.69	50533.88	85728.61	63617.08
73	292	85417.58	49093.49	82724.64	63248.47
74	296	83389.76	49192.67	78419.4	62384.6
75	300	80958.02	49485.05	78298.32	64137.6
76	304	78759.87	49521.68	76239.36	62100.49
77	308	76186.87	49797.73	72934.58	62397.32
78	312	73652.44	49095.3	66694.27	63956.09
79	316	74269.03	48799.96	68944.6	60968.23
80	320	68943.93	50395.7	67080.63	61226.81
81	324	66708.46	49733.73	62866.12	61900.89
82	328	64230.11	49873.16	61897.6	60785.04
83	332	59328.81	45541.6	63063.25	61042.76
84	336	57983.76	47259.87	61762.65	63778.09
85	340	57939.64	48731.11	59380.58	61590.12
86	344	59627.8	46359.68	59241.99	60575.96
87	348	55345.4	47756.31	58890.85	60392.2
88	352	55474.94	48282.67	58422.71	64766.84
89	356	55827.73	48803.78	57146.49	59954.26
90	360	54491.46	46924.29	57845.2	60107.62
91	364	53473.91	48889.7	57108.35	60540.2
92	368	53376.02	48003.81	56666	59919.19
93	372	53546.8	49604.32	54939.19	59998.89
94	376	52269.93	48015.56	54473.11	61883.87
95	380	51203.21	48073.13	54522.14	61862.23
96	384	50800.3	49099.31	53085.12	59126.62
97	388	50036.75	47467.92	53601.8	58647.45
98	392	49738.96	46897.33	52809.16	59580.05
99	396	49504.93	48095.45	51400.68	58843.39
100	400	49108.49	47201.94	51687.47	58219.32
101	404	48044.61	47119.06	51415.27	59893.09
102	408	48136.18	45659.92	51092.12	58521.39
103	412	48257.87	48650.64	49492.45	58183.35
104	416	46999.06	45606.51	50313.71	58044.44
105	420	46638.36	47593.94	49140.03	57904.99
106	424	46182.6	47525.5	48844.14	58926.55
107	428	45429.16	47623.72	47889.36	59209.97
108	432	45221.17	47958.52	48174.03	59447.83
109	436	44196.55	46803.43	48019.92	57756.6
110	440	44125.03	47428.89	47121.02	57369.4
111	444	43897.84	47030.44	46900.16	56955.29
112	448	43724.97	47350.63	46322.63	57058.85
113	452	43759.89	46378.3	46264.44	60043.51
114	456	42948.05	45368.91	46027.87	57552.44
115	460	42640.41	47557.87	45658.19	56649.74
116	464	42553.76	46821.51	45408.01	56701.9
117	468	42061.65	47541.45	45255.3	59108.6
118	472	41430.7	47358.68	44777.49	56195.11
119	476	41203.96	47947.41	44166.36	60520.99
120	480	40621.56	46232.75	43709.54	56045.19
121	484	40551.44	45747.01	43663.65	56158.07
122	488	39980.5	48485.55	43109.27	59433.61
123	492	40006.04	44870.03	42571.54	55695.82
124	496	39999.99	46071.11	42329.09	56015.58
125	500	39422.41	45753.74	42140.56	55625.29
126	504	39739.2	47004.2	41593.88	56963.58
127	508	38433.43	46689.44	41240.57	55916.6
128	512	38641.23	46629.16	40809.04	55595.33
129	516	37910.66	47338.73	40695.47	55791.75
130	520	37622.51	47136.85	40720.99	55238.23
131	524	37377.92	47303.67	40216.51	55384.64
132	528	37346.22	46007.91	40249.06	56021.87
133	532	36957.43	47490.56	39970.68	57631.29
134	536	36319.7	47975.77	39597.81	58972.34
135	540	36624.48	47897.19	38947.87	54777.56
136	544	36272.69	46054.13	39386.24	55131.44
137	548	36164.58	45563.97	38537.11	54647.9
138	552	35631.05	46017.55	38471.24	54874.45
139	556	35586.25	46110.92	38234.39	54182.46
140	560	35177.17	45577.48	38423.18	57699.49
141	564	34724.78	46181.63	37260.49	54456.78
142	568	34697.29	45945.55	37245.91	54302.53
143	572	34164.19	46708.69	37354.92	54229.11
144	576	34273.09	45934.86	36354.15	55788.53
145	580	34115.99	46538.17	36879.39	54439.71
146	584	33942.16	47176.27	36265.62	54297.6
147	588	33282.97	45357.26	35984.45	55132.91
148	592	33026.44	46287.45	35896.05	53899.07
149	596	33018.77	44751.8	35816.56	54333.12
150	600	32580.98	46047.3	34983.75	55530.73
151	604	32423.09	45096.39	35141.62	54009.9
152	608	32160.08	45404.12	34571.59	53551.43
153	612	32162.11	45179.44	34578.19	55305.5
154	616	31801.63	46302.43	34074.6	56124.75
155	620	31627.82	45584.89	33885.96	53559.51
156	624	31341.74	46261.45	33654.23	53492.79
157	628	31051.32	45498.93	33134.62	53076.51
158	632	31035.54	45438.24	33422.97	53988.37
159	636	30588.47	45348.85	32988.2	53280.32
160	640	30373.6	46607.83	32592.63	56325.8
161	644	30304.58	45461.31	32045.99	52596.77
162	648	30112.58	46062.09	32351.07	54746.93
163	652	29954.43	42824.87	31837.03	52914.8
164	656	29687.99	45479.15	31556.81	53509.52
165	660	29544.84	46545.14	31378.04	52777.38
166	664	29444.07	42548.83	31098.86	56705.31
167	668	29176.8	46343.66	31027.26	53228.74
168	672	28915.66	44831.41	30340.72	56004.06
169	676	28851.86	44415.38	30387.67	54805.39
170	680	28590.12	44513.84	30212.15	55491.95
171	684	28305.42	43604.56	29895.25	55748.32
172	688	28480.36	44608.78	29948.74	54246.54
173	692	27998.69	44086.38	29469.82	51980.77
174	696	28259.12	44232.95	29340.03	54728.74
175	700	27432.72	43640.79	29474.79	52095.65
176	704	27455.32	44308.3	29179.97	51987.72
177	708	27273.4	44895.53	28763.31	51743.87
178	712	27291.17	43886.04	28750.51	53977.45
179	716	27153.02	44502.23	28954.17	51464.41
180	720	26996.17	44174.4	28545.46	53566.7
181	724	26852.52	44276.77	28450.45	53922.23
182	728	26577.55	44926.37	28079.59	54722.41
183	732	26456.83	43945.63	27997.4	53259.28
184	736	26148.64	44414.85	27665.92	51829.69
185	740	26341.55	44026.11	27686.66	52603.96
186	744	26214.22	44298.26	27212.51	52903.32
187	748	25840.85	43363.77	27055.98	55113.06


1	threads	mysql	postgres
2	8	34334.84	27332.45
3	12	49981.11	36273.91
4	16	66026.49	43126.32
5	20	85172.59	55683.36
6	24	107950.83	66236.68
7	28	124170.96	66357.53
8	32	133378.91	68531.02
9	36	146829.53	66882.9
10	40	155434.34	67523.37
11	44	163276.88	66443.22
12	48	166352.02	65723.12
13	52	168400.01	63658.09
14	56	169666.51	64303.76
15	60	170631.29	63365.77
16	64	169998	62699.44
17	68	168705.58	62372.26
18	72	167545.74	62598.7
19	76	167227.57	63594.98
20	80	166135.79	62471.26
21	84	164823.18	61606.82
22	88	163712.73	62582.19
23	92	161338.19	62070.58
24	96	161295.98	60867.75
25	100	160486.22	59442.85
26	104	159203.93	61026.47
27	108	158561.82	58759.37
28	112	157001.38	58941.8
29	116	155728.7	59703.55
30	120	154278.76	60795.03
31	124	153537.22	57864.99
32	128	153279.46	58104.71


1	threads	mysql transaction	pg transaction	mysql autocommit	pg autocommit
2	8	39758.32	39208.39	38283.82	36848.5
3	16	70037.81	71072.92	68208.29	64190.02
4	24	116523.78	115122.74	117671.92	82183.06
5	32	150704.83	155785.8	141302.28	94646.67
6	40	168329.8	175801.88	157978.76	93307.65
7	48	189064.77	193869.87	174479.28	90020.26
8	56	199938.46	205938.03	171435.11	84372.25
9	64	188732.16	204638.74	174371.19	89711.37
10	80	192471.25	193361.42	172848.56	84627.48
11	96	186745.07	185738.46	168895.44	84911.03
12	112	171319.29	188973.24	156457.47	84209.33
13	128	134888.66	185154.14	143560.73	79733.64
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39