Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question