| From: | "Ron Harter" <rharter(at)pobox(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Temporal Database |
| Date: | 2002-08-02 04:28:49 |
| Message-ID: | 5Un29.725$my2.36645232@newssvr17.news.prodigy.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)pobox(dot)com | Just an earth bound misfit ... I
| Pink Floyd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2002-08-02 04:48:34 | Re: getpid() function |
| Previous Message | Tom Lane | 2002-08-02 04:23:25 | Re: getpid() function |