Re: Large index scan perfomance and indexCorrelation (PG 8.1.4 Win32)

On Wed, Jun 28, 2006 at 10:37:24AM -0400, Tom Lane wrote:
> with a plain indexscan. What you need to do is compare the two
> functions and figure out what part of the cost models are out of line
> with reality. I tend to agree with the upthread comment that the
> nonlinear interpolation between min_IO_cost and max_IO_cost is suspect

If you're going to make such a comparison (which is badly needed, imho),
http://stats.distributed.net/~decibel/ might be of use to you. It shows
that the nonlinear interpolation between the correlated and uncorrelated
index scans is way off base, at least for this example.

BTW, you'll have a hard time convincing people to increase the cost
estimates of index scans, because experience has shown that they're
already too high (all the discussions about dropping random_page_cost,
for example).
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461