Re: Index on parent/child hierarchy

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
Cc: Jason Armstrong <ja(at)riverdrums(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Index on parent/child hierarchy
Date: 2012-01-31 15:06:25
Message-ID: CAHyXU0wr3hs9cZ6FicgJo+r9gF9Oqf=BwYiTevVWOqJTN=dapQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Jan 29, 2012 at 5:55 AM, Dmitriy Igrishin <dmitigr(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tulio 2012-01-31 15:10:36 Re: parameter "vacuum_defer_cleanup_age"
Previous Message Durumdara 2012-01-31 14:19:32 Re: Extending Session / Logged User info