On Fri, Feb 7, 2020 at 6:29 AM Justin <zzzzz.g...@gmail.com> 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 a complicated query, and/or parallel processing enabled. It could be that a single connection uses 10x work_mem or more. https://www.postgresql.org/docs/current/runtime-config-resource.html
