PostgreSQL View Deadlocks and workarounds

Source: Internet
Author: User

Tags: waiting-o postgres workaround oid from refresh ATI Solution

  • Retrieves the ID of the deadlock process

SELECT * from pg_stat_activity WHERE datname= ' database name ' and waiting= ' t ';
Find the value of the PID column used
Select OID from Pg_class where relname= ' may lock table table '--oid is the ID hidden by each table
Select PID from pg_locks where relation= ' oid ' above detected

  • Kill the process

Select Pg_cancel_backend ("pid value of the deadlock data");
Once you have finished running, refresh the table again and SQL will execute smoothly.

PostgreSQL View Deadlocks and workarounds

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

Tags Index: