| From: | Samuel Gendler <sgendler(at)ideasculptor(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Alan Hodgson <ahodgson(at)simkin(dot)ca>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performance question 83 GB Table 150 million rows, distinct select |
| Date: | 2011-11-16 23:52:35 |
| Message-ID: | CAEV0TzBxOdVjmwGx6rTsuQ7ekUxUo14Ki1aH9dLh_GPZHz4jUQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Nov 16, 2011 at 3:32 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:
>
> If the OP's considering partitioning, they should really consider
> upgrading to 9.1 which has much better performance of things like
> aggregates against partition tables.
>
>
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2011-11-16 23:59:38 | Re: Performance question 83 GB Table 150 million rows, distinct select |
| Previous Message | Scott Marlowe | 2011-11-16 23:32:09 | Re: Performance question 83 GB Table 150 million rows, distinct select |