depends on how soon do you need to access that data after it's being
created, the way I do it in my systems, I get data from 8 points, bit
less than you - but I dump it to csv, and import it on database host
now, you could go to BDB or whatever, but that's not the solution.
So, I would try dumping it to a file, and have separate process, maybe
separete server that would import it, store it, as database. Whatever
you do, as guys said - partition.
In response to
pgsql-performance by date
|Next:||From: Alan McKay||Date: 2009-05-28 16:15:02|
|Subject: Continuent (was: Postgres Clustering)|
|Previous:||From: Alexander Staubo||Date: 2009-05-28 15:34:18|
|Subject: Re: Storing sensor data|