Re: sensible configuration of max_connections

2020-02-07 Thread Michael Lewis
On Fri, Feb 7, 2020 at 6:29 AM Justin wrote: > WorkMem is the biggest consumer of resources lets say its set to 5 megs > per connection at 1000 connections that 5,000 megs that can be allocated. > Clarification- work_mem is used per operation (sort, hash, etc) and could be many many times with

Re: sensible configuration of max_connections

2020-02-07 Thread Justin
Hi Chris Withers As stated each connection uses X amount of resources and its very easy to configure Postgresql where even small number of connections will each up all the RAM WorkMem is the biggest consumer of resources lets say its set to 5 megs per connection at 1000 connections that 5,000 me