Re: [HACKERS] Postgresql performace question

2003-03-03 Thread Greg Copeland
Something I didn't see mentioned of, does your data need to be made available at real time? Just because you're sampling 20/s doesn't have to mean that the data is made available at 20 samples per second or even 1 sample per 1/20th of a second. I mention this because you might find that it's a li

Re: [HACKERS] Postgresql performace question

2003-03-03 Thread Mark Jones
> The real question is, the data collection is in real-time, but can you > have a maintenance window (6 hours a week?) to do things like REINDEX? The database has to have the last 24 hours of data online and be acessable 24 hours a day 7 days a week 365 days a year basicly no downtime. My applica

Re: [HACKERS] Postgresql performace question

2003-03-02 Thread Rod Taylor
> device. As mentioned above I may want to be able to sequentially read records > from the database to be able to recreate the data stream that I received and > recored. I would need to be able to read the records back fast enough to > replay the at the same rate at which I received them. It's

Re: [HACKERS] Postgresql performace question

2003-03-02 Thread Rod Taylor
On Sun, 2003-03-02 at 18:52, Mark Jones wrote: > Hello > > I am working on a project that acquires real-time data from an external > device that I need to store and be able to search through and retrieve > quickly. My application receives packets of data ranging in size from 300 to > 5000 bytes ev

[HACKERS] Postgresql performace question

2003-03-02 Thread Mark Jones
Hello I am working on a project that acquires real-time data from an external device that I need to store and be able to search through and retrieve quickly. My application receives packets of data ranging in size from 300 to 5000 bytes every 50 milliseconds for the minimum duration of 24 hours be