Re: Postgres as Historian

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