"Scott Carey" <[EMAIL PROTECTED]> writes: > The query optimizer fails to use a hash aggregate most of the time. This is > an inconsistent behavior.
Hash aggregation is not used when a DISTINCT aggregate is specified.
DISTINCT forces a sort, so there wouldn't be any advantage.
> Of course DB hints would solve this.
No, they wouldn't.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
