Re: Notice lock waits

On 8/5/16 12:00 PM, Jeff Janes wrote:
> So I created a new guc, notice_lock_waits, which acts like
> log_lock_waits but sends the message as NOTICE so it will show up on
> interactive connections like psql.

I would strongly prefer that this accept a log level instead of being 
hard-coded to NOTICE. The reason is that I find the NOTICE chatter from 
many DDL commands to be completely worthless (looking at you %TYPE), so 
I normally set client_min_messages to WARNING in DDL scripts. I can work 
on that patch; would it essentially be a matter of changing 
notice_lock_waits to int lock_wait_level?
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461