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 _______________________________________________ Maps-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/maps-l
