Re: [GENERAL] Huge number of raws

2004-03-19 Thread Anton Nikiforov
Francisco Reyes ?: On Thu, 18 Mar 2004, Anton Nikiforov wrote: But i'm worry about mentioned centeral database that should store 240 millions of records daily and should collect this data for years. I have not worked with anything even remotely so big. A few thougths.. I think this

Re: [GENERAL] Huge number of raws

2004-03-19 Thread Richard Huxton
On Friday 19 March 2004 08:10, Anton Nikiforov wrote: I do not exactly know how to deal wth such a huge amount of data. The disk subsytem is the must and i do undrstand this. SMP architecture is the must also. I was asking is there any way that data will migrate from fast disk subsystem to

Re: [GENERAL] Huge number of raws

2004-03-19 Thread Francisco Reyes
On Fri, 19 Mar 2004, Anton Nikiforov wrote: Or were you talking about something else like storing different data in different media speeds? (Like Hierarchical Storage Management) I do not exactly know how to deal wth such a huge amount of data. The disk subsytem is the must and i do

[GENERAL] Huge number of raws

2004-03-18 Thread Anton Nikiforov
Dear All! I have a question about how the PostgreSQL will manage a huge number of raws. I have a projet where each half an hour 10 millions of records will be added to the database and they should be calculated, summarized and managed. I'm planning to have a few servers that will receive

Re: [GENERAL] Huge number of raws

2004-03-18 Thread Anton Nikiforov
Anton Nikiforov : Dear All! I have a question about how the PostgreSQL will manage a huge number of raws. I have a projet where each half an hour 10 millions of records will be added to the database and they should be calculated, summarized and managed. I'm planning to have a few servers that