Postgres Pro
Downloads
Home   >   mailing lists

Re: Out of memory error during large hashagg - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Out of memory error during large hashagg
Date
Msg-id 6367.1159113596@sss.pgh.pa.us
Whole thread Raw
In response to Re: Out of memory error during large hashagg  (Casey Duncan <casey@pandora.com>)
Responses Re: Out of memory error during large hashagg
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Casey Duncan
Date:
Subject: Re: Out of memory error during large hashagg
Next
From: "Gene Neely"
Date:
Subject: BUG #2643: Auto trim on insert and update