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