RE: question about index cost estimates - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: question about index cost estimates
Date
Msg-id 000701bfc07b$fbe89f60$2801007e@tpf.co.jp
Whole thread Raw
In response to question about index cost estimates  (Jeff Hoffmann <jeff@propertykey.com>)
Responses Re: question about index cost estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> -----Original Message-----
> From: pgsql-hackers-owner@hub.org [mailto:pgsql-hackers-owner@hub.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@tpf.co.jp 


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: 7.0 RPMS and syslog problem. (more)
Next
From: Jeff Hoffmann
Date:
Subject: Re: question about index cost estimates