Search Postgresql Archives

Re: Service outage: each postgres process use the exact amount of the configured work_mem

Subject: Re: Service outage: each postgres process use the exact amount of the configured work_mem
From: Igor Neyman <ineyman@xxxxxxxxxxxxxx>
Date: Fri, 14 Apr 2017 18:40:39 +0000
Accept-language: en-US
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <6218eb9b-0c94-97f3-1633-5c7f5a85bfc7@evolu-s.it>
References: <d636a713-0b05-00c7-6d9a-5a4719a7f167@evolu-s.it> <CANu8Fixpu_dOGR674jXCPO3TD_q08gbXpCB9hQM1tEWzGKSP6g@mail.gmail.com> <89ad55f2-3a97-2135-c09a-a21b84e081f5@evolu-s.it> <CANu8FixXw3g-fuuPRtyWjDywpe+w+TpO=VfcySo8JXSEOHRmvA@mail.gmail.com> <6218eb9b-0c94-97f3-1633-5c7f5a85bfc7@evolu-s.it>

E. How many users were connected when the problem occurred?

About 350 connections

Thanks

______________________________________________________________________________________

Probably that is your problem, if you don’t have connection pooler.

I’d recommend to start with PgBouncer, very light-weight and easy to configure.

Regards,

Igor Neyman

Follow-Ups:
- Re: Service outage: each postgres process use the exact amount of the configured work_mem
  - From: Moreno Andreo

References:
- Service outage: each postgres process use the exact amount of the configured work_mem
  - From: Moreno Andreo
- Re: Service outage: each postgres process use the exact amount of the configured work_mem
  - From: Melvin Davidson
- Re: Service outage: each postgres process use the exact amount of the configured work_mem
  - From: Moreno Andreo
- Re: Service outage: each postgres process use the exact amount of the configured work_mem
  - From: Melvin Davidson
- Re: Service outage: each postgres process use the exact amount of the configured work_mem
  - From: Moreno Andreo