Temporal Database - Mailing list pgsql-general

From Ron Harter
Subject Temporal Database
Date
Msg-id 5Un29.725$my2.36645232@newssvr17.news.prodigy.com
Whole thread Raw
List pgsql-general
Has anyone used postges to set up a temporal database? What was the
performance like? How was retrieval of the data?
Any comments or problems would be appreciated. We are looking at the
possibility of using postgress to store long term historical data.

The number of data points could be as high 75,000 points. I would expect
between 250-400 updates per second under normal load but during a
disturbance
the update rate could be as high as several thousand per second.

Any comments are appreciated





 --
 Ron Harter                | Tongue, Tied and Twisted
 rharter@pobox.com  | Just an earth bound misfit ... I
                                   |                Pink Floyd





pgsql-general by date:

Previous
From: ville80@salo.salonseutu.fi (9902468)
Date:
Subject: Re: System catalog and identifying
Next
From: "Phil Dobbin"
Date:
Subject: Re: Postgres and Perl: Which DBI module?