Re: Postgres as Historian

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(at)2ndquadrant(dot)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(at)2ndQuadrant(dot)com www.2ndQuadrant.us <http://www.2ndquadrant.us/>
>
>