Re: Infinite loop in pgbench when running COPY command - Mailing list pgsql-hackers

From Anthonin Bonnefoy
Subject Re: Infinite loop in pgbench when running COPY command
Date
Msg-id CAO6_XqoF9TsEmX=A1sVQjvu6jC-UpeoQVOkhozwCy52_Jm2Pmw@mail.gmail.com
Whole thread Raw
In response to Re: Infinite loop in pgbench when running COPY command  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Thu, Oct 2, 2025 at 10:27 AM Michael Paquier <michael@paquier.xyz> wrote:
> Fun.  It seems like nobody has ever tested this scenario, even for a
> COPY TO.  Why did you try that?  Did you have a benchmark scenario in
> mind?

I was trying to trigger pipeline errors while reviewing the
--continue-client-on-abort pgbench patch. And from past experience,
mixing pipelining and COPY is a good way to trigger those.

> That sounds like a good choice to just fail for the time being, all
> these result types don't seem to work (quickly checked).  If somebody
> wants to support this case, we could always sort it out, but I am
> ready to bet that the odds are in the favor of doing nothing.

Yeah, that was also my take.



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Patch for migration of the pg_commit_ts directory
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: Newly created replication slot may be invalidated by checkpoint