Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE

Поиск
Список
Период
Сортировка
От Ulf Lohbrügge
Тема Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Дата
Msg-id CABZYQRJHhYEGXP6W19GoXajC6Ne3N+eUsn3sn_iC3a91xC=QvA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения
2017-11-08 0:45 GMT+01:00 Tom Lane <tgl@sss.pgh.pa.us>:
Ulf Lohbrügge <ulf.lohbruegge@gmail.com> writes:
> I just ran "check_postgres.pl --action=bloat" and got the following output:
> ...
> Looks fine, doesn't it?

A possible explanation is that something is taking an exclusive lock
on some system catalog and holding it for a second or two.  If so,
turning on log_lock_waits might provide some useful info.

                        regards, tom lane

I just checked my configuration and found out that "log_lock_waits" was already enabled.

Unfortunately there is no log output of locks when those long running "SET ROLE" statements occur.

Regards,
Ulf

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Следующее
От: p kirti
Дата:
Сообщение: [PERFORM] DB slowness after upgrade from Postgres 9.1 to 9.4