Comments (8)
giggls
commented on June 25, 2024
If you use hstore-only.style you also need to use indexes-hstore.sql instead of indexes.sql.
Looks like INSTALL-de.md should be extended to reflect this fact.
from openstreetmap-carto-de.
Rolinenik
commented on June 25, 2024
Yes, I wrote it wrong. I have used
./scripts/indexes.py --fillfactor 100 --osm2pgsql --concurrent --prefix planet_osm_hstore --indexes ../indexes-hstore.yml | psql -d gis -f -
to recreate the indexes-hstore.sql statements and execute it subsequent.
Otherwise, I wouldn't have indexes like planet_osm_hstore_point_index
from openstreetmap-carto-de.
giggls
commented on June 25, 2024
Looks fine then
from openstreetmap-carto-de.
giggls
commented on June 25, 2024
/0/0/0.png is not a good tile for testing. Looks like we have some pointless database queries for rendering this single tile. Try something else please. E.g. just call make test
from openstreetmap-carto-de.
Rolinenik
commented on June 25, 2024
OK, I have just called 'make test'. It works but every tile needs 8-17 minutes to render.
from openstreetmap-carto-de.
giggls
commented on June 25, 2024
This might well be a postgresql optimization issue then. I can not reproduce this. make test is reasonably fast on http://tile.openstreetmap.de
from openstreetmap-carto-de.
giggls
commented on June 25, 2024
OK, build time measuring into make test of current master branch.
Looks like this on http://tile.openstreetmap.de a machine with database on ssd:
$ make test 2>/dev/null
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z05.png -u /5/15/10.png
rendering time: 10 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z06.png -u /6/33/20.png
rendering time: 28 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z07.png -u /7/66/43.png
rendering time: 20 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z08.png -u /8/133/87.png
rendering time: 4 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z09.png -u /9/267/175.png
rendering time: 3 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z10.png -u /10/535/351.png
rendering time: 17 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z11.png -u /11/1071/703.png
rendering time: 11 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z12.png -u /12/2143/1406.png
rendering time: 8 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z13.png -u /13/4287/2812.png
rendering time: 4 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z14.png -u /14/8576/5626.png
rendering time: 3 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z15.png -u /15/17153/11252.png
rendering time: 3 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z16.png -u /16/34306/22505.png
rendering time: 2 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z17.png -u /17/68612/45011.png
rendering time: 2 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z18.png -u /18/137225/90022.png
rendering time: 2 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-z19.png -u /19/274450/180045.png
rendering time: 2 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-castle1.png -u /14/8582/5621.png
rendering time: 2 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-castle2.png -u /14/8581/5623.png
rendering time: 2 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-castle3.png -u /18/137259/90022.png
rendering time: 2 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-castle4.png -u /18/137144/90174.png
rendering time: 2 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-camp-caravan.png -u /17/68658/44952.png
rendering time: 2 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-campsite.png -u /18/137346/89837.png
rendering time: 2 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-backcountry.png -u /19/274268/181238.png
rendering time: 2 seconds
./scripts/render_single_tile.py -t -s osm-de.xml -o test-kebab.png -u /19/274475/180053.png
rendering time: 2 seconds
Indexes are generated by indexes-hstore.sql
from openstreetmap-carto-de.
giggls
commented on June 25, 2024
This issue is from before the current databsae Layout change so discussion about these values will no longer make sense. Thus I am closing this.
from openstreetmap-carto-de.
Related Issues (20)
- Use openstreetmap-carto-de with Kosmtik HOT 3
- Duplicate layer amenity-points HOT 1
- Missing entries in download-script available again HOT 4
- Issues with missing fonts HOT 3
- import fails on windows HOT 4
- Hausnummern an Gebäuden immer rendern
- Docker-compose not running HOT 1
- Are you interested in becoming tile layer featured on the OSM main site? HOT 3
- Tile download throws CORS error HOT 4
- Line 59: Wrong URL of get-shapefiles.py HOT 2
- Impossible to use with overv / openstreetmap-tile-server ? HOT 5
- upstream DBSCHEME: column "name_hrb" does not exist HOT 7
- SQL error in water-lines layer HOT 3
- Rendering of municipality names without place=village/town HOT 5
- docker-compose up import issue HOT 1
- error loading project.mml file HOT 5
- lua errors when trying to run osm2pgsql HOT 6
- 11 times slower than old style :( HOT 19
- how to generate osm-de.xml from project.mml HOT 5
- osm2pgsql stops with "error when importing german-latest-osm.pbf" "berlin-latest.osm.pbf is running" HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from openstreetmap-carto-de.