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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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