Re: remove_useless_joins vs. bug #19560

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thom Brown <thom(at)linux(dot)com>
Cc: Richard Guo <guofenglinux(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: remove_useless_joins vs. bug #19560
Date: 2026-07-26 20:34:43
Message-ID: 3315105.1785098083@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
> As for the speed question, I'd not poked at the details of Claude's
> claim, but I guess I should have.

I asked Claude to explain exactly how it arrived at its numbers,
and the answer is that it missed the problem the first time, partly
through not trying to go higher than N=8. Full details attached for
the archives' sake, though I think this is now of mostly academic
interest.

regards, tom lane

Attachment Content-Type Size
benchmark.tar.gz application/gzip 6.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2026-07-26 23:36:09 Re: pg_rewind does not rewind diverging timelines
Previous Message Alexander Lakhin 2026-07-26 20:00:00 aio tests failing on newer Linux kernels