Opened 8 years ago

#3694 new defect

pgsnapshot_load script needs an ANALYZE before the bbox update query

Reported by: ToeBee Owned by: bretth
Priority: major Milestone:
Component: osmosis Version:
Keywords: osmosis, performance, pgsnapshot Cc: toby.murray@…

Description

While trying to load a planet file I first tried to let the pgsnapshot_load script create the bounding boxes and linestrings for ways. However from what I remember seeing in my monitoring graphs it looked like it was going at a couple of ways per hour at which point it would take 3,500 years to complete.

Since the update queries are joining large tables, I believe performance would be greatly improved by putting an ANALYZE statement before the bbox update query on line 41. I ended up letting osmosis build these features in memory on my second attempt which is obviously preferable if you have the RAM. But if not, the script should at least be fast enough to finish before civilization ends.

Change History (0)

Note: See TracTickets for help on using tickets.