Tracking the # of deadlocks

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Tracking the # of deadlocks
Date: 2010-10-27 16:00:35
Message-ID: 20101027120035.93481f17.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Does PG store the # of deadlocks internally anywhere? (like it does
with statistics on how many UPDATE/SELECT/DELETE ops occur on each
table, for example)

I'd like to be tracking this, that way we have an easy way to know if
our software is hitting performance problems by having to retry deadlocked
transactions frequently.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-10-27 16:25:02 Re: Tracking the # of deadlocks
Previous Message Daniel.Crespo 2010-10-27 13:58:13 How to merge data from two separate databases into one (maybe using xlogs)?