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