| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Samuel Gendler <sgendler(at)ideasculptor(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-17 01:58:50 |
| Message-ID: | CAOR=d=2A4jNU+O5Y=aKLaJ37YXAKY7ZnEdw+93gYgLcn7sirAQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Nov 16, 2011 at 4:52 PM, Samuel Gendler
<sgendler(at)ideasculptor(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Colson | 2011-11-17 02:11:18 | Re: Performance question 83 GB Table 150 million rows, distinct select |
| Previous Message | Scott Marlowe | 2011-11-17 01:57:54 | Re: Performance question 83 GB Table 150 million rows, distinct select |