Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem - Mailing list pgsql-general

From Moreno Andreo
Subject Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem
Date
Msg-id 66407273-d3a2-8831-7f96-87ce12771d72@evolu-s.it
Whole thread Raw
In response to Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-general
Tree view
Il 14/04/2017 20:40, Igor Neyman ha scritto:

 

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

 

I'm building such a system, but I don't think that's the problem because now, with 30 active connections, it still does not work (actually it's extremely slow).

Both servers are far from being under heavy load (so they were before...)

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem
Next
From: Moreno Andreo
Date:
Subject: Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem