Home > mailing lists

Re: SELECT AND AGG huge tables - Mailing list pgsql-performance

From	Craig Ringer
Subject	Re: SELECT AND AGG huge tables
Date	October 16, 2012 05:42:49
Msg-id	507CC99C.90508@ringerc.id.au Whole thread Raw
In response to	SELECT AND AGG huge tables (houmanb <houman@gmx.at>)
Responses	Re: SELECT AND AGG huge tables (houmanb <houman@gmx.at>)
List	pgsql-performance

Tree view

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

pgsql-performance by date:

From: Jeff Janes
Date: 16 October 2012, 03:04:41
Subject: Re: SELECT AND AGG huge tables

From: Marinos Yannikos
Date: 16 October 2012, 08:07:28
Subject: Re: Two identical systems, radically different performance

Re: SELECT AND AGG huge tables - Mailing list pgsql-performance

Previous

Next