Re: Storing sensor data

2009/5/28 Kenneth Marshall <ktm@rice.edu>:

>
> One big benefit of partitioning is that you can prune old data with
> minimal impact to the running system. Doing a large bulk delete would
> be extremely I/O impacting without partion support. We use this for
> a DB log system and it allows us to simply truncate a day table instead
> of a delete -- much, much faster.

Thanks. I'll need to investigate how much administrative overhead and
fragility partitioning will introduce since the data will also be
replicated between 2 servers (I'm thinking of using Slony). Any
experience with this combination?