Re: sorting problem - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: sorting problem
Date
Msg-id 20041217211218.GA2119@wolff.to
Whole thread Raw
In response to Re: sorting problem  (Greg Stark <gsstark@mit.edu>)
Responses Re: sorting problem
Re: sorting problem
List 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 by date:

Previous
From: Lonni J Friedman
Date:
Subject: replacements for vacuum?
Next
From: Tom Lane
Date:
Subject: Re: analyze-error: "cannot compare arrays of different element types" revisited