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

From: Philipp Marek <philipp(at)marek(dot)priv(dot)at>
To: Filip Janus <fjanus(at)redhat(dot)com>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] Better Performance for PostgreSQL with large INSERTs
Date: 2025-10-07 12:50:23
Message-ID: b09e68d081019a351a6ed60d0d562bbb@marek.priv.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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!

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Philipp Marek 2025-10-07 13:03:29 Re: [PATCH] Better Performance for PostgreSQL with large INSERTs
Previous Message Matheus Alcantara 2025-10-07 12:40:51 Re: Optimize LISTEN/NOTIFY