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

[Ryan Lambert]

> I see two possible solutions:
> 
> 1. Have a special index method that creates a id index and allow that do be added to the index definition, something like: `... indexes={{column='node_id', method='id-index'}} ....`
> 2. Add an option to the id definition: `... ids = { type = 'node', id_column = 'node_id', create_index = 'always'}, ....`
> 
> The first has the advantage that all indexes are in the same place but it is less obvious what it means and has some potential to be used wrongly. So I'd go for the second option.

I prefer option two as well.

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

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