[OSM-dev] osm2pgsql tile expiry performance

Michael Reichert michael.reichert at geofabrik.de
Tue Jun 4 12:28:38 UTC 2019


Hi,

Am 29.05.19 um 21:40 schrieb j:
> WEEKLY changeset using 0.92:
> -=-=-=-
> time $OSM2PGSQL --append -s -C 3000 -G --hstore -d gis -H $PGHOST -U \
> $PGUSER -r xml changes.osc \
> --flat-nodes /database/postgresql/OSM-FLATNODES --slim \
> --number-processes 4 --style openstreetmap-carto.style \
> --tag-transform-script openstreetmap-carto.lua -e19 -o \
> $WORKDIR_OSM/expired-tiles

Just to ensure that all important test conditions are known.

Do you mean the weekly changesets dump from
https://planet.openstreetmap.org/planet/changesets-latest.osm.bz2? Or
how did you create changes.osc or where did you download it from?
changesets-latest.osm.bz contains changeset metadata only.

Btw, "-H $PGHOST" forces connection via TCP instead of Unix sockets. If
you can use Unix sockets, -H 127.0.0.1 is not required.

Best regards

Michael

-- 
Michael Reichert      www.geofabrik.de
Geofabrik GmbH        Handelsregister: HRB Mannheim 703657
Amalienstr. 44        Geschaeftsfuehrung: C. Karch, F. Ramm
76133 Karlsruhe       Tel: 0721-1803560-3
reichert at geofabrik.de Fax: 0721-1803560-9

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20190604/3a104571/attachment.sig>


More information about the dev mailing list