On Fri, Feb 7, 2020 at 6:29 AM Justin <zzzzz.graf@xxxxxxxxx> 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.
