Why not ask your question on the new OpenStreetMap Community Forum?

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))


index creation on system columns is not supported

asked 09 Sep '20, 14:52

Cellington's gravatar image

accept rate: 0%

edited 09 Sep '20, 14:53

I see, potentially moving on from osmosis.



permanent link

answered 09 Sep '20, 16:16

Cellington's gravatar image

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 ♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 09 Sep '20, 14:52

question was seen: 791 times

last updated: 11 Sep '20, 12:18

powered by OSQA