Re: feature idea: use index when checking for NULLs before SET NOT NULL

From: "John Bachir" <j(at)jjb(dot)cc>
To: "Justin Pryzby" <pryzby(at)telsasoft(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: feature idea: use index when checking for NULLs before SET NOT NULL
Date: 2020-06-02 01:55:43
Message-ID: e3d6e06e-cae0-41f2-b219-58dc37bf4ef2@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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).

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Pryzby 2020-06-02 02:04:47 Re: feature idea: use index when checking for NULLs before SET NOT NULL
Previous Message Martín Marqués 2020-06-02 00:41:13 Re: Read access for pg_monitor to pg_replication_origin_status view