Postgres Pro
Downloads
Home   >   mailing lists

Re: feature idea: use index when checking for NULLs before SET NOT NULL - Mailing list pgsql-hackers

From John Bachir
Subject Re: feature idea: use index when checking for NULLs before SET NOT NULL
Date
Msg-id e3d6e06e-cae0-41f2-b219-58dc37bf4ef2@www.fastmail.com
Whole thread Raw
In response to Re: feature idea: use index when checking for NULLs before SET NOTNULL  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
Tree view 
> Maybe something else had a nontrivial lock on the table, and those commands
> were waiting on lock.  If you "SET deadlock_timeout='1'; SET
> log_lock_waits=on;", then you could see that.

Just checking - I think you mean lock_timeout? (although setting deadlock_timeout is also not a bad idea just in
case).

pgsql-hackers by date:

Previous
From: Martín Marqués
Date:
Subject: Re: Read access for pg_monitor to pg_replication_origin_status view
Next
From: Justin Pryzby
Date:
Subject: Re: feature idea: use index when checking for NULLs before SET NOTNULL