User:Pnorman/jxapi

I ran some benchmarks on my jxapi server pre and post VACUUM ANALYZE;

I also ran them on 8.4 with 4 GB ram and a 4 drive RAID10 and 9.1 with 16 GB ram, a tuned DB and a 6 drive RAID10.

On 9.1 I ran them 3 times. Once with fsync=off and caches not dropped, once with fsync=off and caches dropped, once with fsync=on and caches dropped.

The version of jxapi used for the initial tests did not correctly support : in tag predicates. Although the query included [capacity:disabled=*] it did not use it.

query	pre-VACUUM (8.4)	post-VACUUM (8.4)	9.1 (no drop of caches, fsync=off)	9.1 (fsync=off, dropped caches)	9.1 (fsync=on, dropped caches)	vacuum %change	new DB change (cached, fsync=off)	new DB change (no caches fsync=off)
map?bbox=11.54,48.14,11.543,48.145	00:51.11	00:50.50	00:27.53	00:32.11	00:32.19	-1.19%	-45.49%	-36.40%
*[bbox=11.54,48.14,11.543,48.145]	00:00.52	00:00.42	00:00.67	00:00.51	00:00.46	-20.04%	59.90%	21.48%
*[amenity=library][bbox=-0.57,51.24,0.31,51.75]	07:47.26	07:31.90	02:11.83	02:17.83	02:18.77	-3.29%	-70.83%	-69.50%
node[power=generator]	00:53.73	00:54.99	00:56.82	01:12.21	01:06.60	2.34%	3.33%	31.31%
*[amenity=parking][capacity:disabled=*][bbox=-0.57,51.24,0.31,51.75]	-	-	-	-	-	-	-	-
*[amenity=parking][bbox=-0.57,51.24,0.31,51.75]	19:45.92	15:18.58	06:44.67	06:46.65	06:46.12	-22.54%	-55.95%	-55.73%
*[waterway=sluice_gate]	01:09.19	01:09.28	00:05.64	00:05.14	00:05.17	0.12%	-91.85%	-92.58%
*[bdad6d21a=1378b02bc]	00:00.29	00:00.40	00:00.70	00:00.80	00:00.73	39.86%	75.25%	100.25%
*[power=generator]	06:59.12	05:40.94	02:49.96	02:47.16	02:49.11	-18.65%	-50.15%	-50.97%
map?bbox=11.54,48.14,11.543,48.145	00:38.84	00:38.80	00:02.95	00:00.49	00:00.41	-0.10%	-92.40%	-98.73%
map?bbox=-124,49,-123,50	05:35.72	04:24.11	02:29.28	02:24.31	02:23.16	-21.33%	-43.48%	-45.36%
total	43:41.70	36:29.91	15:50.05	16:07.21	16:02.73	-16.47%	-56.62%	-55.83%