"Scott Carey" <scott(at)richrelevance(dot)com> 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
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2008-06-26 01:12:09|
|Subject: Re: [BUGS] BUG #4128: The postmaster.opts.default file is
|Previous:||From: Scott Carey||Date: 2008-06-25 18:00:33|
|Subject: BUG #4264: Optimizer fails to use hash_aggregate when appropriate.|