"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