Re: sorting problem - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: sorting problem
Date
Msg-id 20041217211934.GB2119@wolff.to
Whole thread Raw
In response to Re: sorting problem  (Bruno Wolff III <bruno@wolff.to>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: analyze-error: "cannot compare arrays of different element types" revisited
Next
From: Tom Lane
Date:
Subject: Re: analyze-error: "cannot compare arrays of different element types" revisited