| From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
|---|---|
| To: | Richard Guo <guofenglinux(at)gmail(dot)com> |
| Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Why is DEFAULT_FDW_TUPLE_COST so insanely low? |
| Date: | 2023-11-02 23:38:26 |
| Message-ID: | CAApHDvqSKX613YPfrxVBW=kLGwkGOLhsxtKrBuL2kee7x0AJ5A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 3 Nov 2023 at 01:02, Richard Guo <guofenglinux(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2023-11-03 00:49:32 | Re: Possible typo in nodeAgg.c |
| Previous Message | Nico Williams | 2023-11-02 23:23:19 | Re: Pre-proposal: unicode normalized text |