Re: Re: Why our counters need to be time-based WAS: WIP: cross column correlation ... - Mailing list pgsql-hackers

From Robert Treat
Subject Re: Re: Why our counters need to be time-based WAS: WIP: cross column correlation ...
Date
Msg-id AANLkTik57s6pAfRaMT85yW4Jsrjv+rxJ_mBF-+K=m-2i@mail.gmail.com
Whole thread Raw
In response to Re: Why our counters need to be time-based WAS: WIP: cross column correlation ...  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
On Mon, Feb 28, 2011 at 4:13 PM, Greg Stark <gsstark@mit.edu> wrote:
> On Mon, Feb 28, 2011 at 6:31 PM, Josh Berkus <josh@agliodbs.com> wrote:
> What's needed here is for someone to write a good mrtg/rrd/whatever
> replacement using postgres as its data store. If you're monitoring
> something sensitive then you would store the data in a *different*
> postgres server to avoid Tom's complaint. There may be aspects of the
> job that Postgres does poorly but we can focus on improving those
> parts of Postgres rather than looking for another database. And
> frankly Postgres isn't that bad a tool for it -- when I did some
> performance analysis recently I actually ended up loading the data
> into Postgres so I could do some of the aggregations using window
> functions anyways.
>

Greg, see https://labs.omniti.com/labs/reconnoiter, but also see
Josh's nearby email about how he's trying to solve this internal to
the database.


Robert Treat
play: xzilla.net
work: omniti.com
hiring: l42.org/Lg


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Native XML
Next
From: Simon Riggs
Date:
Subject: Re: Sync Rep v17