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 Igor Neyman
Subject Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem
Date
Msg-id DM5PR07MB28108363EC7324D6EF1F0FC3DA050@DM5PR07MB2810.namprd07.prod.outlook.com
Whole thread Raw
In response to Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Responses Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem  (Moreno Andreo <moreno.andreo@evolu-s.it>)
List pgsql-general
Tree view

 

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

 

pgsql-general by date:

Previous
From: Rj Ewing
Date:
Subject: Re: [GENERAL] dynamic schema modeling and performance
Next
From: Chris Mair
Date:
Subject: Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem