Re: gistchoose vs. bloat

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: gistchoose vs. bloat
Дата
Msg-id 9994.1358747302@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: gistchoose vs. bloat  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: gistchoose vs. bloat  (Jeff Davis <pgsql@j-davis.com>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Error Building rpm
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Further pg_upgrade analysis for many tables