Re: scary patch contest

From: Xuneng Zhou <xunengzhou(at)gmail(dot)com>
To: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
Cc: Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: scary patch contest
Date: 2026-08-28 03:10:56
Message-ID: CABPTF7V+iM-yGGYWLPjL1P_4_QR-z=NNEF1e6chEm+0w3ga5XQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Zsolt,

On Fri, Aug 28, 2026 at 2:14 AM Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> wrote:
>
> On Wed, 26 Aug 2026, Andres Freund <andres(at)anarazel(dot)de> wrote:
> > I also wonder if we need some more scalable testing here, to test the
> > combination of various interacting features. E.g. something like a perl script
> > that generates the combinatorial combination of features around this being
> > [not] used and verifies that results stay consistent. That could makes it much
> > cheaper (in human time, not necessarily test runtime), to test some of the
> > interactions here.
>
> This gave me the idea to start specifically crosschecking
> feature-interactions with Claude: instead of focusing on reviewing one
> feature, reviewing how 2 or more features interact (for all existing
> features on master, starting with an initial ranking session then
> separate sessions for combinations based on that initial ranking, also
> including 3-or-more feature interactions where it thinks that it would
> be worth a check). The initial ranking itself surfaced 4 actual
> issues, and the few more detailed runs I completed so far from the
> longer task list brought up more questions/issues. The entire list
> will take some time to run, I'll post some bug reports / patches.

Interestingly, although the current SOTA model can do good things
without complicated prompts, it still seems useful for complicated
tasks. Here's a prompt that I plan to give Sol a try.

--
Regards,
Xuneng Zhou
HighGo Software Co., Ltd.

Attachment Content-Type Size
postgresql-cross-feature-interaction-audit-prompt.md text/markdown 36.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Richard Guo 2026-08-28 03:03:37 Re: [PATCH] Fix disabled_nodes propagation for single-child Append paths