Overpass API developpement

[mmd <>]

Am 05.09.2016 um 13:19 schrieb Donal Diamond:
> Thanks for looking at this. My setup was the following:
> 

Thanks a lot for the detailed description.

I have a quick question on the number of area creation runs needed to
reproduce this. After about 25 runs on my local machine, I see some very
slow growth (see below).

In addition to updating the db and updating areas, I also run an the
following osm3s_query in an endless loop:

  (area[~"."~"."];rel(pivot);>;);out geom meta;

I think I mentioned in some other post a few months ago [1], that file
keep growing over time and creating a clone db would bring the db size
down considerably: "Database size grows quite a lot during the update
process. A subsequent clone-db sometimes reduced that size by 50-60GB.
Again I didn't investigate where those large differences come from."

Maybe we're seeing similar effects here?

Do you happen to have any special queries running in parallel on your
machine, especially some long running ones?


208M Sep  5 14:16 area_blocks.bin
3,7K Sep  5 14:16 area_blocks.bin.idx
 12M Sep  5 14:16 areas.bin
  24 Sep  5 14:16 areas.bin.idx
 87M Sep  5 14:16 area_tags_global.bin
 901 Sep  5 14:16 area_tags_global.bin.idx
 28M Sep  5 14:16 area_tags_local.bin
2,8K Sep  5 14:16 area_tags_local.bin.idx
  21 Sep  5 14:11 area_version

-- 

[1] [PerfProject2016] Full attic database creation in 4 days