Re: Out of memory error during large hashagg

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

> 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)?

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