Tim Retout

Integrated monitoring for PostgreSQL

PostgreSQL can collect a variety of statistics about database performance and usage, which administrators can gather with database queries or via SNMP. They can then integrate this data into software such as Munin to produce performance graphs, or Nagios to generate notifications.

This talk will outline the more important measurements that can be made, how to find these across different PostgreSQL releases, and how to use them with monitoring tools to tune the performance of installations.

Bio

Tim works for credativ, a free software consultancy firm which offers support and training for PostgreSQL, among other things. His job involves both system administration and development, to varying degrees.

In his spare time he contributes to a number of free software projects, maintains GNU Enscript, and looks after a few packages for Debian.

Having got bored of helping out at conferences in order to gain free admission, he is now experimenting with speaking at them instead.