Hi! On Mon, 15 Sept 2025 at 18:16, Philipp Marek <[email protected]> wrote: > > Sometimes, storing documents (eg. PDFs) in a database > is much easier than using a separate storage (like S3, NFS, etc.). > > (Because of issues like backup integrity, availability, > service dependencies, access rights, encryption of data, etc..) > > > With this patch: > > ```diff > diff --git i/src/backend/libpq/pqcomm.c w/src/backend/libpq/pqcomm.c > index e517146..936b073 100644 > --- i/src/backend/libpq/pqcomm.c > +++ w/src/backend/libpq/pqcomm.c > @@ -117,7 +117,8 @@ static List *sock_paths = NIL; > */ > > #define PQ_SEND_BUFFER_SIZE 8192 > -#define PQ_RECV_BUFFER_SIZE 8192 > +#define PQ_RECV_BUFFER_SIZE 2097152 > +
Changing this constant will result in an overwhelming increase of memory consumption for instances that work with a large number of connections ( max_connections ~ 1e4) for zero benefit. -- Best regards, Kirill Reshke
