From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com> |
Cc: | "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com>, pgsql-general(at)postgresql(dot)org, Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu> |
Subject: | Re: Out of memory error in 8.1.0 Win32 |
Date: | 2006-06-22 18:10:12 |
Message-ID: | 1908.1150999812@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
"Todd A. Cook" <tcook(at)blackducksoftware(dot)com> writes:
> I am consistently running into out-of-memory issues in 8.1.4 running on
> RHEL3 and 8.0.5 on RHEL4. The logs show entries like this:
> AggContext: -2130714624 total in 271 blocks; 9688 free (269 chunks); -2130724312 used
> TupleHashTable: 893902872 total in 119 blocks; 1088688 free (449 chunks); 892814184 used
Misestimated hash aggregation, perhaps? What is the query and what does
EXPLAIN show for it? What have you got work_mem set to?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Clarence | 2006-06-22 18:23:48 | Re: VACUUM hanging on idle system |
Previous Message | Tom Lane | 2006-06-22 18:01:04 | Re: best way to get PKey and FKey from inside applications (permission pb) |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2006-06-22 18:10:45 | Re: [CORE] GPL Source and Copyright Questions |
Previous Message | A.M. | 2006-06-22 18:09:02 | Re: let's meet |