Message-ID: <gh-pgjdbc-pgjdbc-3811-c3316244336@github.com>
From: "leandrokemp (@leandrokemp)" <noreply+leandrokemp@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Sun, 21 Sep 2025 20:29:00 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3811: PreparedStatement batch performance issue in a loop on v42.7.6 or later
In-Reply-To: <gh-pgjdbc-pgjdbc-3811@github.com>
References: <gh-pgjdbc-pgjdbc-3811@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: leandrokemp
X-GitHub-Comment-Id: 3316244336
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3811
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3811#issuecomment-3316244336
Content-Type: text/plain; charset=utf-8

Thank you pointing that out @vlsi.

I've tested moving ps.toString() outside of the loop and it worked, as you mentioned.
In my program, there is no specific reason for toString() to be inside the loop. So, this resolves the issue for me.

Thank you.