Re: uniquely indexing Celko's nested set model

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Richard Broersma Jr" <rabroersma(at)yahoo(dot)com>
Cc: "General PostgreSQL List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: uniquely indexing Celko's nested set model
Date: 2007-10-20 12:33:17
Message-ID: b42b73150710200533r48eeb14ak52c8335028ed330d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/19/07, Richard Broersma Jr <rabroersma(at)yahoo(dot)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 way to 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-10-20 15:19:20 Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Previous Message Rainer Bauer 2007-10-20 11:22:56 Re: 8.2.3: Server crashes on Windows using Eclipse/Junit