From: Craig Ringer <ringerc@ringerc.id.au>
To: houmanb <houman@gmx.at>
Cc: pgsql-performance@postgresql.org
Subject: Re: SELECT AND AGG huge tables
Date: Tue, 16 Oct 2012 10:42:36 +0800
Message-ID: <507CC99C.90508@ringerc.id.au> (raw)
In-Reply-To: <1350334756457-5728306.post@n5.nabble.com>
References: <1350334756457-5728306.post@n5.nabble.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ringerc@ringerc.id.au, houman@gmx.at
Subject: Re: SELECT AND AGG huge tables
In-Reply-To: <507CC99C.90508@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox