Re: Correlation in cost_index() - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: Correlation in cost_index()
Date
Msg-id Pine.LNX.4.33.0210021405280.3485-100000@css120.ihs.com
Whole thread Raw
In response to Correlation in cost_index()  (Manfred Koizar <mkoi-pg@aon.at>)
Responses Re: Correlation in cost_index()  (Manfred Koizar <mkoi-pg@aon.at>)
Re: Correlation in cost_index()  (Manfred Koizar <mkoi-pg@aon.at>)
Re: Correlation in cost_index()  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-hackers
On Wed, 2 Oct 2002, Manfred Koizar wrote:

> As nobody knows how each of these proposals performs in real life
> under different conditions, I suggest to leave the current
> implementation in, add all three algorithms, and supply a GUC variable
> to select a cost function.

I'd certainly be willing to do some testing on my own data with them.  
Gotta patch?  I've found that when the planner misses, sometimes it misses 
by HUGE amounts on large tables, and I have been running random page cost 
at 1 lately, as well as running cpu_index_cost at 1/10th the default 
setting to get good results.



pgsql-hackers by date:

Previous
From: Manfred Koizar
Date:
Subject: Correlation in cost_index()
Next
From: "Curtis Faith"
Date:
Subject: Advice: Where could I be of help?