Re: Index on parent/child hierarchy

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Index on parent/child hierarchy
Дата
Msg-id CAHyXU0wr3hs9cZ6FicgJo+r9gF9Oqf=BwYiTevVWOqJTN=dapQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index on parent/child hierarchy  (Dmitriy Igrishin <dmitigr@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Durumdara
Дата:
Сообщение: Re: Extending Session / Logged User info
Следующее
От: Tulio
Дата:
Сообщение: Re: parameter "vacuum_defer_cleanup_age"