Re: Fixing some ancient errors in hash join costing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Fixing some ancient errors in hash join costing
Date: 2025-12-28 22:56:40
Message-ID: 2712245.1766962600@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
> I was amused to notice that the postgres_fdw.out change made in my
> patch reverts one made in aa86129e1 (which also affected semijoin
> costing). So we've had trouble before with that test case being
> fundamentally unstable. I wonder if we shouldn't do something to try
> to stabilize it? I see that the test immediately before this one
> forces the matter by turning off enable_sort (which'd affect only
> the local side not the remote). That's a hack all right but maybe
> we should extend it to this test.

Here's a v2 patchset that splits that out as a separate change for
clarity's sake. I also spent a bit of effort on commit log messages,
including researching the git history.

regards, tom lane

Attachment Content-Type Size
v2-0001-Further-stabilize-a-postgres_fdw-test-case.patch text/x-diff 6.6 KB
v2-0002-Ensure-sanity-of-hash-join-costing-when-there-are.patch text/x-diff 39.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jelte Fennema-Nio 2025-12-28 23:25:22 Re: RFC: adding pytest as a supported test framework
Previous Message Konstantin Knizhnik 2025-12-28 20:30:49 Re: index prefetching