[Tile-serving] [openstreetmap/osm2pgsql] Manual index configuration for id indexes? (Issue #1854)

[Jochen Topf]

I noticed a problem with the new manual index creation options as per #1780: The id indexes are explicitly exempt from the configuration. Osm2pgsql will create an id index when it needs the index itself, i.e. when it creates a database for updates. Now if the user needs an index on the id column for some other reason everything is fine as long as we are creating a database for updates, the user can just use the index osm2pgsql creates for itself. But if the database is not created for updates, the user has to add that index to the configuration. But this means the configuration depends on whether the user creates an updatable database or not which is somewhat confusing and annoying for the user, especially because there is a good chance testing is done on a non-updatable database and then the final production import is updatable and the result are two (probably even identical) indexes on the id column.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1854
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/issues/1854 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20221219/75adeaf8/attachment.htm>