Re: Out of memory error during large hashagg

Casey Duncan <casey@pandora.com> writes:
> seed          | st_id   |     164656

> I ran analyze after this, but the results were roughly the same.

What's the statistics target set to, and did you try increasing it?
Can we see the rest of the pg_stats row for this column (I'm mainly
interested in the most-common-value frequencies)?

            regards, tom lane