Recovery conflict monitoring

Magnus Hagander <magnus@hagander.net>

From: Magnus Hagander <magnus@hagander.net>

To: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2010-12-23T12:09:01Z

Lists: pgsql-hackers

Attachments

recovery_conflict_stat.patch (text/x-patch) patch

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/