Does Postgres have any native support for hierarchical data storage?
I'm familiar with the Adjacency List technique, but am trying to
determine whether or not Nested Sets would make sense for our
application or not. I understand that Nested Sets might be better
for high read applications, but write heavy applications suffer from
poor performance.
Any thoughts on the topic?
-M@