[Tile-serving] [openstreetmap/osm2pgsql] Executing custom SQL after Lua insert (Discussion #1768)

[Fabian Freund]

Yes, that would also work. What I'm actually doing is enriching the imported data with information from a nominatim database. Those queries are quite slow due to the huge amount of data (around 150ms per item). Replication will be also a topic later on, data will not be consistent for some time until my after-import script has been executed (which can take up to a few hours). With integrating it into the osm2pgsql import itself I can circumvent possible troubles (which I smell) here. But I see that this doesn't seem to work. I will investigate more what I can do with triggers. Thanks for the Input!

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/discussions/1768#discussioncomment-3682752
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/repo-discussions/1768/comments/3682752 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220919/0be683a0/attachment.htm>