R
R
Rail Khusnutdinov2015-11-22 20:04:41
PostgreSQL
Rail Khusnutdinov, 2015-11-22 20:04:41

Should I use ltree in postgresql? And what is the best way to manually organize a tree structure?

Has anyone used the ltree add-on in postgresql, is it convenient and does it affect performance? And how is it better to organize a structure where there can be only one parent, several children, but each child of the parent must be unique among its own?
For example, from these 4 methods:
Adjacency List (“adjacency list”)
Materialized Path (“materialized path”)
Nested Sets (“nested sets”)
Closure Table (“link table”)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Kirill, 2015-11-22
@kshvakov

Yes, use ltree for postgres: convenient, efficient

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question