This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

OSM Minutely Diff Index Postgresql 10

I previously was able to load a large .pbf file into the APIDB and then use osmosis to do minutely extraction. I would like to test this with postgresql 10, but it seems the previous index on xid (system column) is no longer supported in postgresql 10. Just wondering if something has changed in the indexing on postgresql 10.

Previous index command:

CREATE INDEX nodes_xmin_idx ON nodes USING btree (xid_to_int4(xmin))

Error:

index creation on system columns is not supported

index postgresql

asked 09 Sep '20, 14:52

Cellington
216●9●10●15
accept rate: 0%

edited 09 Sep '20, 14:53

One Answer:

I see, potentially moving on from osmosis.

Reference:

https://github.com/openstreetmap/operations/issues/438

answered 09 Sep '20, 16:16

Cellington
216●9●10●15
accept rate: 0%

This should really only be required if you intend to create diffs from your APIDB, so the issue could perceivably be addressed by adding a flag that indicates if you want this or not (naturally on PG 10 this would not be possible).

(11 Sep '20, 12:17) SimonPoole ♦