Recovery conflict monitoring

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Recovery conflict monitoring
Date: 2010-12-23 12:09:01
Message-ID: AANLkTinHttSDvgSyLXm-YZEyW7Ed+hU6T+nAHz3mYTGW@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This patch adds counters and views to monitor hot standby generated
recovery conflicts. It extends the pg_stat_database view with one
column with the total number of conflicts, and also creates a new view
pg_stat_database_conflicts that contains a breakdown of exactly what
caused the conflicts.

Documentation still pending, but comments meanwhile is of course appreciated ;)

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Attachment Content-Type Size
recovery_conflict_stat.patch text/x-patch 14.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Golub 2010-12-23 12:11:59 Cannot compile Pg 9.0.2 with MinGW under Windows
Previous Message Jan Urbański 2010-12-23 11:38:13 Re: pl/python improvements