Re: [HACKERS] patternsel() and histogram_selectivity() and the hard cutoff of 100

2008-03-08 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: So I had a thought about how to soften the controversial hard cutoff of 100 for the use of the histogram selectivity. Instead of switching 100% one way or the other between the two heuristics why not calculate

Re: [HACKERS] patternsel() and histogram_selectivity() and the hard cutoff of 100

2008-02-12 Thread Matteo Beccati
Hi Greg, So I had a thought about how to soften the controversial hard cutoff of 100 for the use of the histogram selectivity. Instead of switching 100% one way or the other between the two heuristics why not calculate both and combine them. The larger the sample size from the histogram the

[HACKERS] patternsel() and histogram_selectivity() and the hard cutoff of 100

2008-02-05 Thread Gregory Stark
So I had a thought about how to soften the controversial hard cutoff of 100 for the use of the histogram selectivity. Instead of switching 100% one way or the other between the two heuristics why not calculate both and combine them. The larger the sample size from the histogram the more we can

Re: [HACKERS] patternsel() and histogram_selectivity() and the hard cutoff of 100

2008-02-05 Thread Gregory Stark
Gregory Stark [EMAIL PROTECTED] writes: So I had a thought about how to soften the controversial hard cutoff of 100 for the use of the histogram selectivity. Instead of switching 100% one way or the other between the two heuristics why not calculate both and combine them. The larger the