Re: PG19 regression in ecd9288624a: JSON_ARRAY() indexes that go stale

Hi,

On 2026-11-04 23:28:00 +0500, Andrey Borodin wrote:
> > On 4 Nov 2026, at 23:04, Andres Freund <andres(at)anarazel(dot)de> wrote:
> >
> > On 2026-11-03 22:37:52 -0800, Nikolay Samokhvalov wrote:
> >> AI found this while testing v5 and prepared the attached patch; I
> >> haven't manually reviewed the code yet.
> >
> > Personally I think dropping unverified AI code onto the list has almost always
> > negative value, it just increases the already really high noise floor even
> > further. We all can ask LLMs to vomit out code. Putting it on the list
> > basically just means you're asking somebody else to do the actual work.
>
> Do you think there was any human interaction in this thread before your
> message?

Probably not. If indeed automated, I personally find that unacceptable. My
personal view is that anyone caught automatically interacting with the list
should simply be banned after one or two warnings. It just generates noise
without any benefit. We all have access to LLMs, if we want automated
unverified patches, it's dead trivial to set that up. And they very well might
be of higher quality. Just vomiting LLM patches without review and analysis
has purely negative value.

> I like Nik's post transparency.

I think it's good to add it. I still don't see who is helped by getting
unreviewed LLM patches. Whether it's admitted to or not.

> There's no way to escape LLMs. They exist.

I agree. I use LLMs. They're very very useful. I think that's a completely
orthogonal to it being ok / not ok to send stuff that nobody analyzed to
thousands of people. The list is not a chatbot output window.

The lists are clearly getting less and less readable. Parts of that is an
increase in the rate of issues being found - those are ofen real, and we have
to somehow deal with that. Part of that is lots of entities doing automated
patch review via the list. That's not useful and makes seeing actual content
ever harder.

I don'd see how making the lists unreadable is in the interest of even the
biggest LLM fan. Having lots of patches that no human looks at ever doesn't
help anyone. So I think we need to start enforcing some basic rules around
what is and what isn't ok.

Greetings,

Andres Freund