Thread

Re: Infinite loop in pgbench when running COPY command

Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com> — 2025-10-02T09:04:56Z

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.