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? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
