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!