Hi, On 7/1/20 22:18, Tom Browder wrote: > Yesterday I took my first try at using osm2pgsql on a pbm file and, > too late, I realized I didn't take full advantage of the server's > large RAM and multi-core capability.
That's because the task is immensely disk intensive, and all the CPU and RAM sit there bored waiting for the disk to finish, no matter how many cores you try to utilize. If you want to import anything larger than a medium sized country, you will have to upgrade to a SSD or NVMe disk. > + should I dump all the tables created before I start anew? No, osm2pgsl will truncate them on import unless you explicitly ask for an "append". > + I have seen a couple of different postgresql config suggestions. Is > there a one-size fits all or should I tailor it more to my server's > configuration. Most configs you see will be for earlier Postgres versions and hence not necessarily valid for Pg 12. Switching off everything that has to do with "safe writing", e.g. fsync, certainly makes sense (you have to restart the import anyway if you suffer from power failure mid-way, no use in setting up Postgres to avoid data loss when writing). > My PostGIS is the latest Debian package version (version ?). osm2pgsql > is also a package (version ?). > > Should I compile those from source? Not necessary IMHO. > Of course any other advice is welcomed, especially as to which other > pieces are recommended downstream for the actual tile server. And I > would really like to have vector tiles, Vector tiles are produced with a wholly different toolchain, sometimes not even using osm2pgsql at all. Even if you have a toolchain that uses osm2pgsql, it might come with a specific style file it expects you to use on osm2pgsql import... > Oh, for the actual rendering: > > + prefer renderd or tirex? These are raster tile only. Personally I prefer tirex because I am one of its authors. I think it is superior to renderd in every aspect, except that renderd has the larger user base and hence it will be easier to find someone to help you when there's a problem. Bye Frederik -- Frederik Ramm ## eMail frede...@remote.org ## N49°00'09" E008°23'33" _______________________________________________ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk