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