Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group