Re: sensible configuration of max_connections

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: sensible configuration of max_connections
Дата
Msg-id CAHOFxGpni9Mx8XnDTebNC3+H3brK958WpecZxqFAmCzWFe8DXw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: sensible configuration of max_connections  (Justin <zzzzz.graf@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Kasun Kulathunga
Дата:
Сообщение: Re: POLL: Adding transaction status to default psql prompt
Следующее
От: Sam Gendler
Дата:
Сообщение: Re: Fwd: sensible configuration of max_connections