[OSM-dev] Problem With Tirex Render Stack

[Stefan Menzel]

Hello everybody,

I'm still trying tos et up a render Stack Postgis->Mapnik->Tirex->Mod_Tile
it is working right now but, I have a problem rendering some Tiles. I
recognized it first time when I tried to render All Tiles for Zoom 0-10.
When I render Tiles (z=6,x=16,y=16) and (z=6,x=32,y=16) for example I get
a timed out, when I try to render them together. When I render them
seperatly it works. I was trying to find the Mistake tweaking al litte with
the DB Parameters. It seems as if the HDD is to slow or something like that.
Setting up the Timeout in tirex.conf (20min) did not helped. Each querry
process took already has 1GB Ram but it still don't work. The jobs.log
doesn't give any hints. So what can I do?



Best regards

Stefan

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20110614/6b55b3e1/attachment-0001.html>

[Peter Körner]

Each querry process took already has
1GB Ram but it still don?t work. The jobs.log doesn?t give any hints. So
what can I do?

You could take a look at the pg_stat_activity table:

http://www.question-defense.com/2008/11/12/postgres-table-pg_stat_activity-table-fields-explained

Peter

[Stefan Menzel]

HI Peter,
this shows me the currently working queries. Is there a way to see which
query was not successfully or how much time which query took?

Best regards

Stefan


-----Urspr?ngliche Nachricht-----
Von: Peter K?rner [mailto:osm-lists at mazdermind.de]
Gesendet: Dienstag, 14. Juni 2011 17:21
An: Stefan Menzel
Cc: dev at openstreetmap.org
Betreff: Re: [OSM-dev] Problem With Tirex Render Stack

Each querry process took already has
1GB Ram but it still don?t work. The jobs.log doesn?t give any hints. So
what can I do?

You could take a look at the pg_stat_activity table:

http://www.question-defense.com/2008/11/12/postgres-table-pg_stat_activity-t
able-fields-explained

Peter