Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem
Дата
Msg-id DM5PR07MB28108C7E9A50CB9EB3A52978DA050@DM5PR07MB2810.namprd07.prod.outlook.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Ответы Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Список pgsql-general

 

From: Moreno Andreo [mailto:moreno.andreo@evolu-s.it]
Sent: Friday, April 14, 2017 3:00 PM
To: Igor Neyman <ineyman@perceptron.com>; Melvin Davidson <melvin6925@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

 

Attention: This email was sent from someone outside of Perceptron. Always exercise caution when opening attachments or clicking links from unknown senders or when receiving unexpected emails.

 

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...)

Having total of 350 connections and only 30 of them being active, is the exact case where connection pooler helps.

Igor Neyman

 

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Moreno Andreo
Дата:
Сообщение: Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem
Следующее
От: Moreno Andreo
Дата:
Сообщение: Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem