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

From: Igor Neyman <ineyman(at)perceptron(dot)com>
To: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>, Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Service outage: each postgres process use the exact amount of the configured work_mem
Date: 2017-04-14 18:40:39
Message-ID: DM5PR07MB28108363EC7324D6EF1F0FC3DA050@DM5PR07MB2810.namprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Mair 2017-04-14 18:42:02 Re: Service outage: each postgres process use the exact amount of the configured work_mem
Previous Message Rj Ewing 2017-04-14 18:37:47 Re: dynamic schema modeling and performance