Postgres Pro
Downloads
Home   >   mailing lists

Re: uniquely indexing Celko's nested set model - Mailing list pgsql-general

From Merlin Moncure
Subject Re: uniquely indexing Celko's nested set model
Date
Msg-id b42b73150710200533r48eeb14ak52c8335028ed330d@mail.gmail.com
Whole thread Raw
In response to uniquely indexing Celko's nested set model  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: uniquely indexing Celko's nested set model  (Michael Glaesemann <grzm@seespotcode.net>)
Re: uniquely indexing Celko's nested set model  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
Tree view 
On 10/19/07, Richard Broersma Jr <rabroersma@yahoo.com> wrote:
> Is it possible to constraint both the LEFT and RIGHT fields of a record to use the same index?  I am looking for a
wayto ensure for all LEFTs and RIGHTs in a table, that is it is impossible for any LEFT or RIGHT to have to same value. 

I found the celko's approach to be not very scalable...if you do any
inserts at all into the tree the table will thrash terribly.  Have you
eliminated other approaches, such as arrays, ltree, etc?

merlin

pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Next
From: Tom Lane
Date:
Subject: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit