[rrd-developers] RRD PostgreSQL extension

[Tobias Oetiker]

Hi Dustin,

Yesterday Dustin Fisch wrote:

> Hi,
>
> I am currently thinking about building an RRD extension for PostgreSQL.
>
> The extension will provide a RRD data type which represents a
> complete database and functions for all the existing functions of the
> RRD tool, like create, update, first and graph...
>
> PostgreSQL has a nice API for LOB, which allows to store the whole RRD
> database using the PostgreSQL file management.
>
> I already have taken a look to the RRD code. As far as I can see, there
> are functions like rrd_create_r(...) which provides the functionality I
> need for such an extension.
>
> The PostgreSQL LOB API currently provides a file descriptor for the
> access to the data stored in the LOB.
>
> Unfortunately, it looks like the RRD API only allows the usage of a
> filename.
>
> Is there any way to use a file descriptor instead of the filename? Or
> is there any chance such a patch would be accepted?

if done nicely, I'll be glad to integrate such a patch ... I guess
you would have to compile without mmap support ...

how would this pg integration work, would the rrd data be stored in
a blob ? wouldn't this get read from disk entirely on every update
and make things rather slow ?

cheers
tobi


-- 
Tobi Oetiker, OETIKER+PARTNER AG, Aarweg 15 CH-4600 Olten, Switzerland
http://it.oetiker.ch tobi at oetiker.ch ++41 62 775 9902 / sb: -9900