User:Pnorman/jxapi
Jump to navigation
Jump to 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% |