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

Re: Finding deadlocks on postgresql ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Machiel Richards <machielr(at)rdc(dot)co(dot)za>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Finding deadlocks on postgresql ?
Date: 2010-08-13 13:38:37
Message-ID: 22249.1281706717@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Machiel Richards <machielr(at)rdc(dot)co(dot)za> writes:
>          As part of creating a Daily health check for  some postgresql
> databases, I am trying to determine whether the database have any
> deadlocks.

I'm not sure what you're imagining you need to do here.  Deadlocks are
not persistent conditions in Postgres --- they're detected and one of
the competing transactions is rolled back to remove the deadlock.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Rikard BosnjakovicDate: 2010-08-14 21:30:03
Subject: Help with trigger
Previous:From: Edi StojicevicDate: 2010-08-13 12:36:23
Subject: Re: Finding deadlocks on postgresql ?

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