Re: Out of memory error during large hashagg

[Casey Duncan <casey(at)pandora(dot)com>]

On Sep 24, 2006, at 8:59 AM, Tom Lane wrote:

> Casey Duncan <casey(at)pandora(dot)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)?

Here's the full pg_stats row:

 public     | seed      | st_id |         0 |         8 |     138674  
|  
{42151109694333522,66226913946054313,108711403296197641,1351772151143018 
06,1130147629642373,1597650524892734,16434507676114329,17430059620571257 
,22269564345616346,28879557667799977} |  
{0.001,0.001,0.001,0.001,0.000666667,0.000666667,0.000666667,0.000666667 
,0.000666667,0.000666667} |  
{69337952030227,23194309459225658,44727149474281842,67399809385152536,93 
773403960447474,116874916355760832,138282618203581456,141866119873210938 
,145491433047267294,149167246450593786,152782384850071963} |    0.829168

I haven't tried increasing the stats target. What would be a suitable  
value to try?

Thanks

-Casey