Re: Performance question 83 GB Table 150 million rows, distinct select - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Performance question 83 GB Table 150 million rows, distinct select
Date
Msg-id CAOR=d=2A4jNU+O5Y=aKLaJ37YXAKY7ZnEdw+93gYgLcn7sirAQ@mail.gmail.com
Whole thread Raw
In response to Re: Performance question 83 GB Table 150 million rows, distinct select  (Samuel Gendler <sgendler@ideasculptor.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Performance question 83 GB Table 150 million rows, distinct select
Next
From: Andy Colson
Date:
Subject: Re: Performance question 83 GB Table 150 million rows, distinct select