[Tile-serving] [osm2pgsql] large postgres shared_buffers slows down import (#163)

[Hannes Janetzek]

For the current import I use PostgreSQL 9.4 package (9.4~beta1-2.pgdg12.4+1) with latest osm2pgsql. Though the minutely updates to the old import and same shared_buffer settings for 9.3 had also a relation read speed about 7/sec. When the current import is done I can try to reduce the custom settings and to reproduce the benchmark with a smaller imports

```
shared_buffers = 64GB 
temp_buffers = 64MB
maintenance_work_mem = 4GB
### import: off
fsync = off
### import: off
synchronous_commit = off
### import: off
full_page_writes = off
### import: 100 / 3
checkpoint_segments = 100
autovacuum = off
effective_cache_size = 64GB
```

```
osm2pgsql -c  -p planet --hstore-all --hstore-column "name:" --number-processes 32 -P 5433 -U osm -d osm --cache 32000 --flat-nodes /ssd/osm/nodes --slim -i ssd_indexes -S ../opensciencemap.style /ssd/tmp/planet-140618.osm.pbf
```

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/163#issuecomment-47135693
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20140625/ca9eb4cb/attachment.html>