On Wed, Nov 16, 2011 at 4:52 PM, Samuel Gendler <sgendler@xxxxxxxxxxxxxxxx> wrote: > Could you elaborate on this a bit, or point me at some docs? I manage a > 600GB db which does almost nothing but aggregates on partitioned tables - > the largest of which has approx 600 million rows across all partitions. > grouping in the aggregates tends to be on the partition column and rarely, > if ever, would a group cross multiple partitions. We're on 9.0 and could > definitely use some performance gains. It's covered in the release notes for 9.1: http://developer.postgresql.org/pgdocs/postgres/release-9-1.html -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
