[Tile-serving] [osm2pgsql] Allow method of specifying custom partial indexes (#166)

Paul Norman notifications at github.com
Wed Jul 16 19:10:51 UTC 2014


> Creating indices during import is likely to be a bad idea.
> 
> First, updating an index while inserting N row one bye one is much more expensive than first inserting N rows in a table and then building the index over the complete set of rows. This is because after each insertion the index has to be kept in sync with the table data.

This is an argument about creating indexes during ``COPY``, not during import. The import process *already* includes index creation, after the data in the tables is loaded. This would just be changing the index creation.

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/166#issuecomment-49212374
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20140716/06a886aa/attachment.html>


More information about the Tile-serving mailing list