[collectd] ANN: DBstore for collectd - store metrics in a RDBMS (postgres)

[Florian Forster]

Hi Bob,

On Thu, Apr 23, 2009 at 09:14:19PM -0600, Bob Cotton wrote:
> I've put together a collectd perl write plugin that will store
> collectd metrics in a postgres database.
> 
> Have a look. It's only been used in very small installations so
> feedback is welcome.
> 
> http://github.com/bcotton/collectd_dbstore/tree/master

I've met and talked to some people in the last few days that have
*a lot* more database background than I do. And they told me that adding
data to a table is usually not a problem at all, even if there are
millions of datasets per table. *The* problem seems to be deleting old
data, because indices get degenerated. Using the partitioning you
suggest seems to be *the* way around this, because you can use
`DROP TABLE' to remove old data, which is fast.

I'll take a look at your code in the next few days and give it a try.

Regards,
-octo
-- 
Florian octo Forster
Hacker in training
GnuPG: 0x91523C3D
http://verplant.org/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://mailman.verplant.org/pipermail/collectd/attachments/20090501/30a35fd8/attachment.pgp