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

От

Moreno Andreo

Тема

Дата

14 апреля 2017 г. в 22:00:24

Msg-id

66407273-d3a2-8831-7f96-87ce12771d72@evolu-s.it

обсуждение

Ответ на

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

Список

pgsql-general

Дерево обсуждения

[GENERAL] Service outage: each postgres process use the exact amount of theconfigured work_mem Moreno Andreo <moreno.andreo@evolu-s.it> 14 апреля 2017 г. в 20:12:13

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Jeff Janes <jeff.janes@gmail.com> 14 апреля 2017 г. в 21:05:13

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Melvin Davidson <melvin6925@gmail.com> 14 апреля 2017 г. в 20:33:11

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Moreno Andreo <moreno.andreo@evolu-s.it> 14 апреля 2017 г. в 20:50:52

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Chris Mair <chris@1006.org> 14 апреля 2017 г. в 21:08:10

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Melvin Davidson <melvin6925@gmail.com> 14 апреля 2017 г. в 21:01:41

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Moreno Andreo <moreno.andreo@evolu-s.it> 14 апреля 2017 г. в 21:28:43

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Melvin Davidson <melvin6925@gmail.com> 14 апреля 2017 г. в 21:36:57

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Chris Mair <chris@1006.org> 14 апреля 2017 г. в 21:42:02

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Melvin Davidson <melvin6925@gmail.com> 14 апреля 2017 г. в 21:55:33

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Moreno Andreo <moreno.andreo@evolu-s.it> 14 апреля 2017 г. в 22:01:54

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Igor Neyman <ineyman@perceptron.com> 14 апреля 2017 г. в 21:40:39

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Moreno Andreo <moreno.andreo@evolu-s.it> 14 апреля 2017 г. в 22:00:24

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Igor Neyman <ineyman@perceptron.com> 14 апреля 2017 г. в 22:06:18

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Moreno Andreo <moreno.andreo@evolu-s.it> 14 апреля 2017 г. в 22:10:53

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem Igor Neyman <ineyman@perceptron.com> 14 апреля 2017 г. в 22:15:59

Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem [(AUTO-RE)SOLVED...] Moreno Andreo <moreno.andreo@evolu-s.it> 15 апреля 2017 г. в 00:40:40

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

Предыдущее

От: Melvin Davidson

Дата: 14 апреля 2017 г. в 21:55:33

Сообщение: Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem

Следующее

От: Moreno Andreo

Дата: 14 апреля 2017 г. в 22:01:54

Сообщение: Re: [GENERAL] Service outage: each postgres process use the exactamount of the configured work_mem