Re: logging of transaction related events

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Kent Tong <kent(at)cpttm(dot)org(dot)mo>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: logging of transaction related events
Date: 2007-11-21 22:43:51
Message-ID: 200711212243.lALMhp815055@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kent Tong wrote:
>
> Hi,
>
> Is it possible to log events related to transactions, in particular, about
> blocking? For example:
>
> INFO: transaction 123 is blocked waiting for locked held by transaction
> 456.

8.3 will have a log_lock_waits parameter which will do something like
that.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2007-11-21 22:53:08 Re: Coordinating database user accounts with active directory
Previous Message Richard Huxton 2007-11-21 22:32:11 Re: Coordinating database user accounts with active directory