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

2025-09-15 Thread Philipp Marek
Hi Kirill, 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. No, it's not that bad. 1) With this being allocated in the bss segment, the RAM will only be

[PATCH] Better Performance for PostgreSQL with large INSERTs

2025-09-15 Thread Philipp Marek
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/lib

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

2025-09-15 Thread Kirill Reshke
Hi! On Mon, 15 Sept 2025 at 18:16, Philipp Marek 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 d