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

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

[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

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 every