Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group