Re: sensible configuration of max_connections - Mailing list pgsql-general

From Michael Lewis
Subject Re: sensible configuration of max_connections
Date
Msg-id CAHOFxGpni9Mx8XnDTebNC3+H3brK958WpecZxqFAmCzWFe8DXw@mail.gmail.com
Whole thread Raw
In response to Re: sensible configuration of max_connections  (Justin <zzzzz.graf@gmail.com>)
List pgsql-general

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


pgsql-general by date:

Previous
From: Kasun Kulathunga
Date:
Subject: Re: POLL: Adding transaction status to default psql prompt
Next
From: Sam Gendler
Date:
Subject: Re: Fwd: sensible configuration of max_connections