[Tile-serving] [mod_tile] mod_tile works extemely slow (#90)

[nicon89]

Hi,

I got virtual server (Xen) with Ubuntu 14.04.1 installed and:
24 virtual cores,
128GB RAM,
2TB HDD
and I'm experiencing extremely slow renders for a planet snapshot.

My postgresql.conf:
max_connections = 1200
shared_buffers = 4GB
temp_buffers = 128MB
work_mem = 512MB
maintenance_work_mem = 32GB
effective_io_concurrency = 6
fsync = on
synchronous_commit = on
full_page_writes = off
checkpoint_segments = 32
checkpoint_timeout = 10min
checkpoint_completion_target = 0.9
effective_cache_size = 24GB
autovacuum = on

renderd.conf:
[renderd]
socketname=/var/run/renderd/renderd.sock
num_threads=24
tile_dir=/var/lib/mod_tile
stats_file=/var/run/renderd/renderd.stats

[mapnik]
plugins_dir=/usr/lib/mapnik/2.0/input/
font_dir=/usr/share/fonts/truetype/ttf-dejavu
font_dir_recurse=1

[default]
URI=/osm_tiles/
TILEDIR=/var/lib/mod_tile
XML=$OWN_STYLE$
TILESIZE=256

During renderd I'm getting a lot errors like:
renderd[32087]: DEBUG: Failed to read cmd on fd 16
Or:
renderd[32087]: ERROR: failed to render TILE default 7 72-79 40-47
renderd[32087]:    reason: Postgis Plugin: bad connection

Generating tile can take even 5000 seconds.

What can I do to fix it?

Thank you in advance for help.

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/mod_tile/issues/90
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20141109/7ac9f710/attachment.html>