Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Postgresql Database Lock Problem - Mailing list pgsql-docs

From Scott Marlowe
Subject Re: [GENERAL] Postgresql Database Lock Problem
Date
Msg-id dcc563d10911171255h243e5da2m8f773344dd8f707@mail.gmail.com
Whole thread Raw
In response to Postgresql Database Lock Problem  (shohorab hossain <shohorab23@yahoo.com>)
Responses Re: [GENERAL] Postgresql Database Lock Problem  (shohorab hossain <shohorab23@yahoo.com>)
List pgsql-docs
Tree view 
Next time this is happening join the pg_lock table to the
pg_stat_activity table to see which query is holding the lock for a
bazillion milliseconds, while it's happening.  That query / statement
may give you some clue what's wrong.

pgsql-docs by date:

Previous
From: shohorab hossain
Date:
Subject: Postgresql Database Lock Problem
Next
From: shohorab hossain
Date:
Subject: Re: [GENERAL] Postgresql Database Lock Problem