Re: memory usage of group by select - Mailing list pgsql-general

Alvaro Herrera <alvherre@commandprompt.com> writes:
> It's expecting 85k distinct groups.  If that's not accurate, then
> HashAggregate would use more memory than expected.  See if you can make
> it work by setting enable_hashagg = off.

> If that works, good -- the real solution is different.  Maybe you need
> to ANALYZE more, or increase the size of the stats bin for this column.

If ANALYZE consistently underestimates the number of distinct values,
you may have to force matters with ALTER TABLE SET STATISTICS DISTINCT.

            regards, tom lane