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:

active answers oldest answers newest answers popular answers

I see, potentially moving on from osmosis.

Reference:

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

permanent link

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 ♦

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

learn more about Markdown

Question tags:

postgresql ×165
index ×17

question asked: 09 Sep '20, 14:52

question was seen: 1,102 times

last updated: 11 Sep '20, 12:18

OSM Minutely Diff Index Postgresql 10

Follow this question

Related questions