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

asked 09 Sep '20, 14:52

Cellington's gravatar image

Cellington
21681015
accept rate: 0%

edited 09 Sep '20, 14:53


I see, potentially moving on from osmosis.

Reference:

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

permanent link

answered 09 Sep '20, 16:16

Cellington's gravatar image

Cellington
21681015
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

By RSS:

Answers

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:

×160
×13

question asked: 09 Sep '20, 14:52

question was seen: 222 times

last updated: 11 Sep '20, 12:18

powered by OSQA