Justin Pryzby wrote: > detail|Process 26871 waits for ShareLock on transaction 13693505; blocked by > process 26646. > Process 26646 waits for ShareLock on transaction 13693504; blocked by process > 26871. > Process 26871: SELECT db_column_name,table_name FROM > huawei_m2000_counter_details ORDER BY ctid FOR UPDATE > Process 26646: SELECT db_column_name,table_name FROM > huawei_m2000_counter_details ORDER BY ctid FOR UPDATE
Uh, this is locking the whole table. Is there no useful WHERE? What you should be doing is SELECT WHERE <key values> ORDER BY <key> FOR UPDATE where <key> is indexed. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
