Hi Steve,
Its literally the same query. I would try to extract the actual named object
that is in the lock to verify. Is there any partitioning? An explain plan
may be helpful.
Thank you
Travis
From: Dirschel, Steve
Sent: Tuesday, October 31, 2023 4:12 PM
To: pgsql-performa...@postgresq
"Dirschel, Steve" writes:
> Above I can see PID 3740 is blocking PID 3707. The PK on table
> wln_mart.ee_fact is ee_fact_id. I assume PID 3740 has updated a row
> (but not committed it yet) that PID 3707 is also trying to update.
Hmm. We can see that 3707 is waiting for 3740 to commit, because
