Re: [PATCH] Better Performance for PostgreSQL with large INSERTs

Philipp Marek <philipp@marek.priv.at>

From: Philipp Marek <philipp@marek.priv.at>
To: Filip Janus <fjanus@redhat.com>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2025-10-07T12:50:23Z
Lists: pgsql-hackers
Hi Filip,

> 7% is an interesting improvement for these cases. I see it as a nice
> feature,
> What about adding a GUC variable to have the ability to configure
> PQ_RECV_BUFFER_SIZE based on the user's needs?

Well, currently this is just the array size as a preprocessor macro,
so the executables .bss gets sized differently.

For a GUC quite some more code, including dynamical allocation
_and reallocation_ would be needed -- and this complexity I wanted
to avoid for the first discussion.


If a GUC fits the usage patterns better, I'm okay with it!