Postgres Pro
Downloads
Home   >   mailing lists

Re: Out of memory error in 8.1.0 Win32 - Mailing list pgsql-general

From Tom Lane
Subject Re: Out of memory error in 8.1.0 Win32
Date
Msg-id 1908.1150999812@sss.pgh.pa.us
Whole thread Raw
In response to Re: Out of memory error in 8.1.0 Win32  ("Todd A. Cook" <tcook@blackducksoftware.com>)
Responses Re: Out of memory error in 8.1.0 Win32
List pgsql-general
Tree view 
"Todd A. Cook" <tcook@blackducksoftware.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: best way to get PKey and FKey from inside applications (permission pb)
Next
From: "Todd A. Cook"
Date:
Subject: Re: Out of memory error in 8.1.0 Win32