Re: sorting problem

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: sorting problem
Дата
Msg-id 20041217211934.GB2119@wolff.to
обсуждение исходный текст
Ответ на Re: sorting problem  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
On Fri, Dec 17, 2004 at 15:12:18 -0600,
  Bruno Wolff III <bruno@wolff.to> wrote:
> 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.

That should have been 2N-1 nodes.

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

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