Re: SELECT AND AGG huge tables

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: houmanb <houman(at)gmx(dot)at>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SELECT AND AGG huge tables
Date: 2012-10-16 02:42:36
Message-ID: 507CC99C.90508@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 10/16/2012 04:59 AM, houmanb wrote:

> There is an Index on T.c. But would it help to partition the table by T.c?

You should really post EXPLAIN ANALYZE for questions like this. See

https://wiki.postgresql.org/wiki/Slow_Query_Questions

--
Craig Ringer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marinos Yannikos 2012-10-16 05:07:14 Re: Two identical systems, radically different performance
Previous Message Jeff Janes 2012-10-16 00:04:34 Re: SELECT AND AGG huge tables