On Thu, May 28, 2009 at 05:24:33PM +0200, Ivan Voras wrote: > 2009/5/28 Kenneth Marshall <ktm@xxxxxxxx>: > > > > > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
