On Tue, Jan 31, 2006 at 03:11:50PM -0800, Jeffrey W. Baker wrote:
> On Tue, 2006-01-31 at 17:06 -0600, Jim C. Nasby wrote:
> > On Tue, Jan 31, 2006 at 12:36:31PM -0800, Jeffrey W. Baker wrote:
> > > Random page cost - should possible to determine this at runtime
> >
> > Before worrying about random_page_cost at all it makes a lot more sense
> > to look at the query cost estimates, some of which are pretty far out of
> > wack.
>
> I agree, but this problem is orthogonal, no?
No. The problem is that random_page_cost has the wrong effect in some of
the cost functions, so even if you set it more accurately you're not
buying anything. In fact, you might well be hurting performance.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461