Reporter: ToeBee
[Submitted to the original trac issue database at 1.44pm, Sunday, 17th April 2011]

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.