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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
