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: (view raw or whole 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.

yeah -- good point.


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-2015 The PostgreSQL Global Development Group