osm2pgsql icon indicating copy to clipboard operation
osm2pgsql copied to clipboard

Start middle table indexing once processing is finished

Open pnorman opened this issue 9 years ago • 1 comments

With in-memory pending, the middle tables are only read from once processing is finished. This allows us to build indexes right away, including the GIN index on planet_osm_ways.nodes, which is often slower than the rest of the import.

By starting it sooner, it will make the pending ways and other indexes no longer part of the critical path for import speed on a --slim import. It might increase contention for disk, but this is probably not an issue.

Moved from MapQuest/osm2pgsql#15

pnorman avatar Oct 25 '14 08:10 pnorman

There is no longer a processing stage, so this is not possible in this way. However, the indexing still might be moved a little bit ahead. The way-node index can already be created while relations are still being imported.

lonvia avatar Feb 14 '19 22:02 lonvia