Re: Out of memory error during large hashagg

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