Re: [PATCH] Better Performance for PostgreSQL with large INSERTs - Mailing list pgsql-hackers

From Philipp Marek
Subject Re: [PATCH] Better Performance for PostgreSQL with large INSERTs
Date
Msg-id b09e68d081019a351a6ed60d0d562bbb@marek.priv.at
Whole thread Raw
In response to Re: [PATCH] Better Performance for PostgreSQL with large INSERTs  (Filip Janus <fjanus@redhat.com>)
List 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!



pgsql-hackers by date:

Previous
From: Matheus Alcantara
Date:
Subject: Re: Optimize LISTEN/NOTIFY
Next
From: Philipp Marek
Date:
Subject: Re: [PATCH] Better Performance for PostgreSQL with large INSERTs