Re: gistchoose vs. bloat

Jeff Davis <pgsql@j-davis.com> writes:
> On Fri, 2012-12-14 at 18:36 +0200, Heikki Linnakangas wrote:
>> BTW, I don't much like the option name "randomization". It's not clear 
>> what's been randomized. I'd prefer something like 
>> "distribute_on_equal_penalty", although that's really long. Better ideas?

> I agree that "randomization" is vague, but I can't think of anything
> better.

I looked at this patch.  ISTM we should not have the option at all but
just do it always.  I cannot believe that always-go-left is ever a
preferable strategy in the long run; the resulting imbalance in the
index will surely kill any possible benefit.  Even if there are some
cases where it miraculously fails to lose, how many users are going to
realize that applies to their case and make use of the option?
        regards, tom lane