Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common
Дата
Msg-id CAMsr+YEBRuNgwv9yjOT5St2hWVhMZMSomGxtdREX6=nqNFv9Ew@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common  (milist ujang <ujang.milist@gmail.com>)
Ответы Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common  (milist ujang <ujang.milist@gmail.com>)
Список pgsql-general
Дерево обсуждения
On 3 October 2017 at 19:45, milist ujang <ujang.milist@gmail.com> wrote:
Hi all,

I've an environment 9.4 + bdr: 
PostgreSQL 9.4.4

You're on a pretty old  postgres-bdr. Update. You're missing a lot of fixes from mainline.
 
This is consolidation databases, in this machine there are around 250+ wal sender processes.

Not a great use case for BDR.
 
Consider pglogical.
 

finally get which processes (wal senders) that are using mutexes:

perf top -e task-clock -p 55382


Can you get stacks please?

Use -g

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: milist ujang
Дата:
Сообщение: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common
Следующее
От: milist ujang
Дата:
Сообщение: Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common