Index on member_id

[Piotr P]

Hi,

The documentation (https://imposm.org/docs/imposm3/latest/relations.html) says:

"Both osm_id and member_id columns are indexed in PostgreSQL by default to speed up these joins."

However, I cannot see any index created on the member_id column in by DB and I cannot find any piece of code that creates such an index.

Am I missing something or is it a missing feature / mistake in the documentation?

Cheers,

Piotr

[Imre Samu]

> However, I cannot see any index created on the member_id column in by DB 

maybe  member_index ?

see https://github.com/omniscale/imposm3/blob/master/test/route_relation_mapping.yml

tables:
  master_routes:
    type: relation_member
    columns:
    - name: osm_id
      type: id
    - name: member
      type: member_id
    - name: index
      type: member_index
    - name: role
      type: member_role
    - name: type
      type: member_type

...

if you test ./test/route_relation_mapping.yml  - can you see any index ?

Regards,

 Imre

--
--
_______________________________________________
Imposm mailing list
imp...@googlegroups.com
http://groups.google.com/group/imposm

---
You received this message because you are subscribed to the Google Groups "imposm" group.
To unsubscribe from this group and stop receiving emails from it, send an email to imposm+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/imposm/0deec85b-5c10-46d1-94fe-001245562b13n%40googlegroups.com.

[Piotr P]

To clarify,  I am talking about DB index. To speed up joins.

[Imre Samu]

If there is no index, it is possible that the documentation is inaccurate.

( disclaimer: This part is little known to me, and when I did, I didn't need an index. ) 

To view this discussion on the web visit https://groups.google.com/d/msgid/imposm/9051b839-61d9-4339-94d7-5f7c8887147cn%40googlegroups.com.