User:Pnorman/jxapi

From OpenStreetMap Wiki
Jump to: navigation, search

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%