Re: Postgres hangs for the query "lock table <Tablename> in exclusive mode"

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Vinodh NV <linktovinodh(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres hangs for the query "lock table <Tablename> in exclusive mode"
Date: 2018-02-23 05:58:48
Message-ID: CAKFQuwY=ZQV7E76B3qd9z25D9qoup0DJOEF8T1QNqmOf4gLfDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday, February 22, 2018, Vinodh NV <linktovinodh(at)gmail(dot)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.

https://www.postgresql.org/docs/9.6/static/view-pg-locks.html

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message PT 2018-02-23 11:02:13 Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later
Previous Message Paul Jungwirth 2018-02-23 05:45:51 Re: Given a set of daterange, finding the continuous range that includes a particular date