On Wed, Nov 16, 2011 at 4:52 PM, Samuel Gendler
<sgendler@ideasculptor.com> 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