Re: Why is DEFAULT_FDW_TUPLE_COST so insanely low? - Mailing list pgsql-hackers

From David Rowley
Subject Re: Why is DEFAULT_FDW_TUPLE_COST so insanely low?
Date
Msg-id CAApHDvqSKX613YPfrxVBW=kLGwkGOLhsxtKrBuL2kee7x0AJ5A@mail.gmail.com
Whole thread Raw
In response to Re: Why is DEFAULT_FDW_TUPLE_COST so insanely low?  (Richard Guo <guofenglinux@gmail.com>)
List 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 by date:

Previous
From: Nico Williams
Date:
Subject: Re: Pre-proposal: unicode normalized text
Next
From: Bruce Momjian
Date:
Subject: Re: Possible typo in nodeAgg.c