Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres hangs for the query "lock table in exclusive mode" - Mailing list pgsql-general

From David G. Johnston
Subject Re: Postgres hangs for the query "lock table in exclusive mode"
Date
Msg-id CAKFQuwY=ZQV7E76B3qd9z25D9qoup0DJOEF8T1QNqmOf4gLfDQ@mail.gmail.com
Whole thread Raw
In response to Postgres hangs for the query "lock table in exclusive mode"  (Vinodh NV <linktovinodh@gmail.com>)
List pgsql-general
Tree view
On Thursday, February 22, 2018, Vinodh NV <linktovinodh@gmail.com> wrote:

Postgres hangs for the query "lock table <Tablename> in exclusive mode"
Can you please let me know what could be the reason and how to resolve it?


Not readily, but that's why the pg_locks view exists.


David J.
 

pgsql-general by date:

Previous
From: Paul Jungwirth
Date:
Subject: Re: Given a set of daterange, finding the continuous range thatincludes a particular date
Next
From: PT
Date:
Subject: Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later