[Tile-serving] [openstreetmap/osm2pgsql] Multiple VS/Postgres/Postgis versions on Appveyor (#1391)

[mmd]

I tested http://download.geofabrik.de/europe/germany/saarland-latest.osm.pbf on _pgsql_ backend:

```
2021-01-11 13:25:42  osm2pgsql version 1.4.0
2021-01-11 13:25:46  Database version: 13.1 (Debian 13.1-1.pgdg100+1)
2021-01-11 13:25:46  PostGIS version: 3.1
2021-01-11 13:25:46  Node-cache: cache=800MB, maxblocks=12800*65536, allocation method=1
2021-01-11 13:25:46  Setting up table 'planet_osm_point'
2021-01-11 13:25:46  Setting up table 'planet_osm_line'
2021-01-11 13:25:46  Setting up table 'planet_osm_polygon'
2021-01-11 13:25:46  Setting up table 'planet_osm_roads'
2021-01-11 13:25:59  Reading input files done in 12s.
2021-01-11 13:25:59    Processed 3944443 nodes in 0s - 3944k/s
2021-01-11 13:25:59    Processed 716882 ways in 11s - 65k/s
2021-01-11 13:25:59    Processed 5293 relations in 1s - 5k/s
2021-01-11 13:26:00  Clustering table 'planet_osm_point' by geometry...
2021-01-11 13:26:00  Clustering table 'planet_osm_line' by geometry...
2021-01-11 13:26:00  node cache: stored: 3944443(100.00%), storage efficiency: 50.00% (dense blocks: 0, sparse nodes: 3944443), hit rate: 100.00%
2021-01-11 13:26:00  Clustering table 'planet_osm_roads' by geometry...
2021-01-11 13:26:00  Clustering table 'planet_osm_polygon' by geometry...
2021-01-11 13:26:01  Creating geometry index on table 'planet_osm_roads'...
2021-01-11 13:26:03  Analyzing table 'planet_osm_roads'...
2021-01-11 13:26:03  Creating geometry index on table 'planet_osm_point'...
2021-01-11 13:26:04  All postprocessing on table 'planet_osm_roads' done in 4s.
2021-01-11 13:26:08  Analyzing table 'planet_osm_point'...
2021-01-11 13:26:09  All postprocessing on table 'planet_osm_point' done in 9s.
2021-01-11 13:26:09  Creating geometry index on table 'planet_osm_line'...
2021-01-11 13:26:11  Analyzing table 'planet_osm_line'...
2021-01-11 13:26:12  All postprocessing on table 'planet_osm_line' done in 12s.
2021-01-11 13:26:22  Creating geometry index on table 'planet_osm_polygon'...
2021-01-11 13:26:29  Analyzing table 'planet_osm_polygon'...
2021-01-11 13:26:29  All postprocessing on table 'planet_osm_polygon' done in 29s.
2021-01-11 13:26:29  osm2pgsql took 43s overall.
```

Both 2015 + 2019 builds were in a 37-46s time range across a number of testruns. Results on 9.6 were similar in that run times were rather close to each other.

I guess this must be something on AppVeyor side that is slowing down unit tests.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/pull/1391#issuecomment-757921768
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210111/ea914ecf/attachment.htm>