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 DM5PR07MB28108363EC7324D6EF1F0FC3DA050@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
Дерево обсуждения

 

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 по дате отправления:

Предыдущее
От: Rj Ewing
Дата:
Сообщение: Re: [GENERAL] dynamic schema modeling and performance
Следующее
От: Chris Mair
Дата:
Сообщение: Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem