Marco Di Cesare <marco.dices...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance