PGMon - partitioning

The amount of data collected by PGMon may be quite significant, and it may cause serious problems regarding their processing (the more data the slower queries) and maintenance (collected data become stale quite quickly, and deleting large amounts of data may cause problems in PostgreSQL). Partitioning represents relatively effective solution of these problems.

pgmon partitioning

PGMon - installation and config

A brief description of installation and config of the PGMon project. As this project has two separate and more or less independent parts - a part responsible for data collection and a web interface used to display collected data - it's necessary to install and configure both of these parts.

pgmon installation configuration

PGMon - database structure

This article contains brief description of database structure used for the PGMon project - tables, their structure, etc.

pgmon database structure