Re: sorting problem

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: sorting problem
Дата
Msg-id 20041217211218.GA2119@wolff.to
обсуждение исходный текст
Ответ на Re: sorting problem  (Greg Stark <gsstark@mit.edu>)
Ответы Re: sorting problem
Re: sorting problem
Список pgsql-general
On Fri, Dec 17, 2004 at 15:36:58 -0500,
  Greg Stark <gsstark@mit.edu> wrote:
>
> Isn't that still nlog(n)? In the end you're going to have read in every page
> of the index including all those non-leaf pages. Aren't there nlog(n) pages?

The depth of the tree is log N, but there are only N nodes. I think you
can treat the amount of information at each node as constant.

В списке pgsql-general по дате отправления:

Предыдущее
От: Lonni J Friedman
Дата:
Сообщение: replacements for vacuum?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: analyze-error: "cannot compare arrays of different element types" revisited