On Wed, Jul 1, 2020 at 15:18 Tom Browder <[email protected]> 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. ...
Okay, I'm making progress, thanks to you all. First, lesson learned (as suggested by all): I used Antarctica pbm as a test bed for import which showed an immediate problem with osm2pgsql. Thanks to Sarah about the requirement for a current osm2pgsql. I wound up compiling and installing from source which made the import process work. Strangely, that version shows as 1.2.0 while the Buster backports shows version 1.21! Thanks to Paul for the postgresql settings I made for work_mem and maintenance_work_mem (and the size catch by Martin!). As to suggestions to change other postgresql settings I got mixed signals. One I didn't ask about was autovacuum on or off? I plan to try Frederik's tirex at some point after I get a working server. Finally, thanks to Julien for the links to his vector tile work. I will have to study that a bit more later. Cheers! -Tom _______________________________________________ talk mailing list [email protected] https://lists.openstreetmap.org/listinfo/talk
