Re: gistchoose vs. bloat - Mailing list pgsql-hackers

From Tom Lane
Subject Re: gistchoose vs. bloat
Date
Msg-id 9994.1358747302@sss.pgh.pa.us
Whole thread Raw
In response to Re: gistchoose vs. bloat  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: gistchoose vs. bloat
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Error Building rpm
Next
From: Jeff Janes
Date:
Subject: Re: Further pg_upgrade analysis for many tables