RE: question about index cost estimates

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Jeff Hoffmann" <jeff(at)propertykey(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: question about index cost estimates
Date: 2000-05-18 03:48:52
Message-ID: 000701bfc07b$fbe89f60$2801007e@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: pgsql-hackers-owner(at)hub(dot)org [mailto:pgsql-hackers-owner(at)hub(dot)org]On
> Behalf Of Jeff Hoffmann
>

[snip]

>
> pages_fetched = ceil(baserel->pages * log(tuples_fetched /
> baserel->pages + 1.0));
>

Unfortunately I didn't understand this well either.

pages_fetched seems to be able to be greater than
baserel->pages. But if there's sufficiently large buffer
space pages_fetched would be <= baserel->pages.
Are there any assupmtions about buffer space ?

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message ts 2000-05-18 04:25:08 Re: Trigger function languages
Previous Message Lamar Owen 2000-05-18 03:37:10 Re: 7.0 RPMS and syslog problem. (more)