| 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 |
| 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 |