Re: Index on parent/child hierarchy - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Index on parent/child hierarchy
Date
Msg-id CAHyXU0wr3hs9cZ6FicgJo+r9gF9Oqf=BwYiTevVWOqJTN=dapQ@mail.gmail.com
Whole thread Raw
In response to Re: Index on parent/child hierarchy  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-general
On Sun, Jan 29, 2012 at 5:55 AM, Dmitriy Igrishin <dmitigr@gmail.com> wrote:
>> The point here is that you can exploit the tree structure with a btree
>> index.  Before we got recursive queries, this was often the best way
>> to do it, but now it's kind of a niche solution to be used when
>> certain things fall into place.
>>
>> merlin
>
> Another approarch  is to use ltree. It's easy and robust.
> http://www.postgresql.org/docs/9.1/static/ltree.html

yeah -- good point.

merlin

pgsql-general by date:

Previous
From: Durumdara
Date:
Subject: Re: Extending Session / Logged User info
Next
From: Tulio
Date:
Subject: Re: parameter "vacuum_defer_cleanup_age"