Re: Performance impact of lowering max_files_per_process

2018-01-23 Thread Thomas Kellerer
Thomas Kellerer schrieb am 19.01.2018 um 17:48: > > I wonder what performance implications that has on a server with > around 50-100 active connections (through pgBouncer). > > My understanding of the documentation is, that Postgres will work > just fine if we lower the limit, it simply releases t

Performance impact of lowering max_files_per_process

2018-01-19 Thread Thomas Kellerer
We have a customer project where Postgres is using too many file handles during peak times (around 150.000) Apart from re-configuring the operating system (CentOS) this could also be mitigated by lowering max_files_per_process. I wonder what performance implications that has on a server with a