Re: [GENERAL] Postgresql Database Lock Problem

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: shohorab hossain <shohorab23(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Postgresql Database Lock Problem
Date: 2009-11-17 20:55:25
Message-ID: dcc563d10911171255h243e5da2m8f773344dd8f707@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-docs pgsql-general

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Julius Tuskenis 2009-11-18 07:45:52 Practice of backups
Previous Message Tom Lane 2009-11-17 19:47:53 Re: Postgresql Database Lock Problem

Browse pgsql-docs by date

  From Date Subject
Next Message shohorab hossain 2009-11-18 08:17:06 Re: [GENERAL] Postgresql Database Lock Problem
Previous Message Tom Lane 2009-11-17 19:47:53 Re: Postgresql Database Lock Problem

Browse pgsql-general by date

  From Date Subject
Next Message Naoko Reeves 2009-11-17 20:55:53 Re: does encrypt function support higher than basic ascii?
Previous Message Loyal 2009-11-17 20:45:22 Re: Experience with many schemas vs many databases