Hello,
Two weeks ago I started a new open source software project (FireAlarm, http://sourceforge.net/projects/firealarm/) which helps to detect performance problems on Firebird SQL servers - by continuous analysis of system tables which are very similar to the PostgreSQL Statistics Views.
While I am still new to PostgreSQL and have real world experience with DB2 InterBase and Firebird only I am interested to write a similar tool for PostgreSQL.
Maybe there are articles or discussions which help to get an introduction to the practical usage of PostgreSQL Statistics Views, like typical queries used to identify potential problems? Just to give an example: on InterBase and Firebird, long running transactions can cause performance problems, and a typical system monitoring task is to find the clients or processes with the oldest transactions (older than x minutes).
Regards -- Michael Justin http://www.habarisoft.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
