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-24 15:59:56
Message-ID: 6367.1159113596@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:
> 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2006-09-24 21:15:59 Re: BUG #2649: wish: provide multi-row INSERT with
Previous Message Maciej Pilichowski 2006-09-24 06:44:44 BUG #2649: wish: provide multi-row INSERT with VALUES