Adjacency Lists vs Nested Sets - Mailing list pgsql-general

From Matthew Hixson
Subject Adjacency Lists vs Nested Sets
Date
Msg-id 7200DF10-586D-41CA-9CD4-DE32A1B2A999@poindextrose.org
Whole thread Raw
Responses Re: Adjacency Lists vs Nested Sets
List pgsql-general
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@

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Duplicate Unique Key constraint error
Next
From: Richard Huxton
Date:
Subject: Re: Adjacency Lists vs Nested Sets