Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE - Mailing list pgsql-performance

From Tom Lane
Subject Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Date
Msg-id 13706.1510098347@sss.pgh.pa.us
Whole thread Raw
In response to [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE  (Ulf Lohbrügge <ulf.lohbruegge@gmail.com>)
Responses Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
List pgsql-performance
Tree view 
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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Ulf Lohbrügge
Date:
Subject: Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE
Next
From: Ulf Lohbrügge
Date:
Subject: Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE