Hi all, New version of pg_statsinfo and pg_stats_reporter are released! http://pgfoundry.org/frs/?group_id=1000422&release_id=2055 http://pgfoundry.org/frs/?group_id=1000422&release_id=2056
They support PostgreSQL 9.3 and working on XFS file system. In XFS supports, thanks very much for Claus Koch! Reports of pg_stats_reporter become more visual and intuitive. * Sample report of new pg_stats_reporter is under following. http://pgstatsinfo.projects.pgfoundry.org/files/report_sample.html Change logs in these versions are under following. [Change logs of pg_statsinfo] * Work on PostgreSQL 9.3. * Add collective statistics under following. - Maximum number of backend - Unit of parameter values in postgresql.conf * Change default pg_statsinfo outputed log file name to "pg_statsinfo.log". * Add configuration which enable or disable alert functions, it can set each alert item freely. * Add under following alert function - Correlations in each tables - Maximum number of backends - Empty disk space in tablespace - Load average - Amount of disk swap - Amount of replication delay * Change output checkpoint log and auto vacuum log messages in pg_statsinfo's text log. -- - Before version is'nt output these log messages intentionally. * Add collecting statistics in restartpoint in standby server * Add fall-back mode if repository database server is not collectly working or not connecting. - Before version, pg_statsinfo output error logs until fixed. * Add report items in command-line reporting feature. - Amount of replication delay - Number of executed and execution time in auto analyze - Unit of parameter values in postgresql.conf * Add command of pg_statsinfo agent operations. - Stop pg_statsinfo agent - Start pg_statsinfo agent [Change logs of pg_stats_reporter] * Add feature of creating report by command-line(CUI). - Can create reports by crond in a period - Create an index of report list together with a report. * Add report item which is replication delay. * Add highlight button for period of CHECKPOINT executed time at each graphs. * Add report item which is unit of parameters in "Setting Parameters". * Change animation setting in dygraphs * Can works normally without php-intl rpm package. - If you doesn't install php-intl rpm package, it shows messages in only English. These software are BSD Licence. Please use them in your postgres! Regards, -- Mitsumasa KONDO NTT Open Source Software Center
