Postgres Pro
Downloads
Home   >   mailing lists

Re: Query with large number of joins - Mailing list pgsql-performance

From Tom Lane
Subject Re: Query with large number of joins
Date
Msg-id 6155.1413910232@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query with large number of joins  (Marco Di Cesare <Marco.DiCesare@pointclickcare.com>)
Responses Re: Query with large number of joins
List pgsql-performance
Tree view 
Marco Di Cesare <Marco.DiCesare@pointclickcare.com> writes:
>                 COUNT(DISTINCT "foxtrot_india"."bravo_romeo")

Ah.  That explains why the planner doesn't want to use a hash aggregation
step --- DISTINCT aggregates aren't supported with those.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query with large number of joins
Next
From: Björn Wittich
Date:
Subject: extremly bad select performance on huge table