Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-docspgsql-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

pgsql-docs by date

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

pgsql-admin by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group