| 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: | Whole Thread | Raw Message | 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 |