Postgres as Historian

From: Hardik Belani <hardikbelani(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Postgres as Historian
Date: 2010-08-02 07:20:18
Message-ID: AANLkTimCVJUrqbrmq0LpWy=8kAfye9xsBu-yMUri8igC@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

We are using postgres as RDBMS for our product. There is a requirement
coming for a feature which will require me to store data about various data
points (mainly numbers) on a time scale. Data measurement is being taken
every few secs/mins based and it is needed to be stored for statistical
analysis. Now this requires numbers (integers/floats) to be stored at every
mins.

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..

We already are using postgres for our product so using postgres does not add
any additional installation requirement and hence it is a bit easier.

Would you recommand postgres for this kind of requirement and will be
provide the performance. OR do you recommand any other database meant
for such requirements. I am also searching for a good historian database if
postgres doesn't suppport.

Thanks,
Hardik

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Markus Wanner 2010-08-02 07:36:24 Re: english parser in text search: support for multiple words in the same position
Previous Message Pavel Stehule 2010-08-02 06:46:13 Re: review: xml_is_well_formed