Re: Out of memory error during large hashagg

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Casey Duncan <casey(at)pandora(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Out of memory error during large hashagg
Date: 2006-09-25 19:02:42
Message-ID: 12436.1159210962@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Casey Duncan <casey(at)pandora(dot)com> writes:
> I haven't tried increasing the stats target. What would be a suitable
> value to try?

Try 100 (instead of the default 10) ... you can go as high as 1000,
though hopefully that's overkill.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-09-26 02:02:14 Re: BUG #2651: 8.2 - beta 1 does now compile with Sun Studio 11
Previous Message Casey Duncan 2006-09-25 18:39:55 Re: Out of memory error during large hashagg