Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres as Historian - Mailing list pgsql-hackers

From Hardik Belani
Subject Re: Postgres as Historian
Date
Msg-id AANLkTimOEeqOmnU7x=btgkZsyVG=ufoAf3NszEUNHUw0@mail.gmail.com
Whole thread Raw
In response to Re: Postgres as Historian  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-hackers
Tree view
 
Thanks for all your responses and my apologies for putting the question in the wrong list.
 
I think OLAP is the answer for my requirements.
 
Regards,
Hardik


 
On Wed, Aug 4, 2010 at 5:40 AM, Greg Smith <greg@2ndquadrant.com> wrote:
Hardik Belani wrote:
For this i can create a table with number and time (may be time offset instead of timestamp) as columns. But still it will require me to store huge number of rows in the order of few millions. Data is read only and only inserts can happen. But I need to perform all kinds of aggregation to get various statistics. for example: daily avg, monthly avg etc..
 


You've unfortunately asked on the wrong list about this.  pgsql-hackers is intended mainly for discussion related to the source code of PostgreSQL, so this is off-topic for it.  The people who like to argue about the best way to implement aggregates and the like are on the pgsql-performance list.  You'd be more likely to get detailed responses if you asked this question there.  That group loves to talk about how to design things for other people.


--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us


pgsql-hackers by date:

Previous
From: Boxuan Zhai
Date:
Subject: Re: merge command - GSoC progress
Next
From: Yeb Havinga
Date:
Subject: Re: tracking inherited columns (was: patch for check constraints using multiple inheritance)