Re: Storing sensor data - Mailing list pgsql-performance

From Kenneth Marshall
Subject Re: Storing sensor data
Date
Msg-id 20090528171213.GG18879@it.is.rice.edu
Whole thread Raw
In response to Re: Storing sensor data  (Ivan Voras <ivoras@freebsd.org>)
List pgsql-performance
On Thu, May 28, 2009 at 05:24:33PM +0200, Ivan Voras wrote:
> 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?
>

We use Slony1 on a number of databases, but none yet on which we
use data partitioning.

Cheers,
Ken

pgsql-performance by date:

Previous
From: Alan McKay
Date:
Subject: Continuent (was: Postgres Clustering)
Next
From: Fabrix
Date:
Subject: Scalability in postgres