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 no

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 more

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 th