Am 16.08.2011 12:04, schrieb Kai Krueger:
On 08/15/2011 12:58 PM, Peter Körner wrote:
Hi
Am 12.08.2011 17:37, schrieb Kai Krueger:
r25070: Make use of prepared geometries from geos-3.1+. These dramatically speed up the polygon tests used by the advanced multipolygon handling code.
r26292: Implement pgsql_nodes_get_list to speed up way and relation processing
we're now running r26543 (intarray branch), let's see if it is faster.
Unfortunately, the first batch didn't look to promising that it was any faster. :-( The majority of the time is still spent in processing relations it seems, with a single relation taking multiple seconds to process. I will try and see if I can at some point figure out what stage of processing relations takes so long, although that would presumably require to rebuild osm2pgsql with some extra instrumentation.
I don't see problems with that. We're free to add debug output and recompile.
Earlier, when connecting directly to the database and trying to run some test queries, I noticed that I got some odd error messages. I can't remember the exact wording, but it was something along the line that it failed to write a temporary transaction log file. I am not sure how reproducible that error is, or if it is connected to the crash in osm2pgsql, but it may give some hints.
I guess the postgress logs could tell us about that, but unfortunately I don't know where to look for the logs (hint: it's not var/log ;)
Peter