Re: Why is DEFAULT_FDW_TUPLE_COST so insanely low?

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Why is DEFAULT_FDW_TUPLE_COST so insanely low?
Дата
Msg-id CAApHDvqSKX613YPfrxVBW=kLGwkGOLhsxtKrBuL2kee7x0AJ5A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why is DEFAULT_FDW_TUPLE_COST so insanely low?  (Richard Guo <guofenglinux@gmail.com>)
Список pgsql-hackers
On Fri, 3 Nov 2023 at 01:02, Richard Guo <guofenglinux@gmail.com> wrote:
> It seems that the test is still not stable on 32-bit machines even after
> 4b14e18714.  I see the following plan diff on cfbot [1].

I recreated that locally this time.  Seems there's still flexibility
to push or not push down the sort and the costs of each are close
enough that it differs between 32 and 64-bit.

The fix I just pushed removes the flexibility for doing a local sort
by turning off enable_sort.

Thanks for the report.

David



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

Предыдущее
От: Nico Williams
Дата:
Сообщение: Re: Pre-proposal: unicode normalized text
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Possible typo in nodeAgg.c