Re: Storing sensor data - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: Storing sensor data
Date
Msg-id 2f4958ff0905280839s1c7da43dh9c95ba7ce4ce30bb@mail.gmail.com
Whole thread Raw
In response to Re: Storing sensor data  (Alexander Staubo <alex@bengler.no>)
List pgsql-performance
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
(separate server).
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.

pgsql-performance by date:

Previous
From: Alexander Staubo
Date:
Subject: Re: Storing sensor data
Next
From: Alan McKay
Date:
Subject: Continuent (was: Postgres Clustering)