Re: gistchoose vs. bloat

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: gistchoose vs. bloat
Дата
Msg-id 1358751462.992.80.camel@jdavis
обсуждение исходный текст
Ответ на Re: gistchoose vs. bloat  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: gistchoose vs. bloat  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, 2013-01-21 at 00:48 -0500, Tom Lane wrote:
> 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?

Sounds good to me.

If I remember correctly, there was also an argument that it may be
useful for repeatable test results. That's a little questionable for
performance (except in those cases where few penalties are identical
anyway), but could plausibly be useful for a crash report or something.

Regards,Jeff Davis




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Removing PD_ALL_VISIBLE
Следующее
От: Миша Тюрин
Дата:
Сообщение: standby, pg_basebackup and last xlog file