[Tile-serving] [openstreetmap/osm2pgsql] osm2pgsql fails to create "osm_id" indexes on PostgreSQL 14 (Issue #1674)

[mboeringa]

I will try the logging option in osm2pgsql on a Liechtenstein extract.

For what it is worth: deleting 87M records from a 462M record data set of OpenStreetMap buildings takes just 30 minutes in both PG13 and PG14 using some Python scripting I created and a:

`DELETE FROM <TABLE_A> a USING <TABLE_B> b WHERE a.objectid = b.objectid`

type of SQL statement. The fact that the timings are the same, at least shows there is no wholesale regression issue in processing DELETE for PG14 versus 13.

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

Message ID: <openstreetmap/osm2pgsql/issues/1674/1132076038 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220519/362590e6/attachment.htm>