pg-collectd provides an (unofficial) alternative and opinionated postgres 
collectd writer plugin, where flexibility is traded in for performance and ease 
of use.

https://github.com/nickbabcock/pg-collectd

- It achieves a 4x reduction in db cpu usage compared to using collectd's 
default postgres writer + setup
- If one is running Debian based system and collectd 5.4+ (eg: Ubuntu 14.04+) 
one can `dpkg -i` the provided debs. If using another distro, one can compile 
from source (Rust).
- pg-collectd works by flattening the collectd metrics and `COPY` them directly 
to the db.

Depending on your use case, this plugin won't replace collectd's native 
postgres plugin as:

- pg-collectd must insert into a single table
- pg-collectd must insert into a table called "collectd_metrics" (work in 
progress)
- pg-collectd cannot communicate over TLS (work in progress)

Anyways, if anyone has thoughts or suggestions please share them or raise an 
issue.

-Nick.
_______________________________________________
collectd mailing list
collectd@verplant.org
https://mailman.verplant.org/listinfo/collectd

Reply via email to