From: | laser <laser(at)toping(dot)com(dot)cn> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: out of memory problem in CVS |
Date: | 2005-07-04 07:49:30 |
Message-ID: | 42C8EA0A.6080000@toping.com.cn |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane 写道:
>Neil Conway <neilc(at)samurai(dot)com> writes:
>
>
>>Have you run ANALYZE recently? You might be running into the well-known
>>problem that hashed aggregation can consume an arbitrary amount of
>>memory -- posting the EXPLAIN for the query would confirm that.
>>
>>
>
>It would be useful to confirm whether this behavior is any different
>from 8.0 ...
>
>
>
Ok, rerun the query in another 8.0.3 box, it comes with 1G RAM and it's
linux,
without the 512M data segment limit (ulimit -d unlimited)。Load the data
and run vacuum analyze; then run the query, now the query return the result,
through top, we found that the postmaster process used 600+M RAM, the
enable_hashagg is ON.
wish that helps.
regards laser
From | Date | Subject | |
---|---|---|---|
Next Message | David Pratt | 2005-07-04 13:27:04 | Re: Trigger help Solved |
Previous Message | laser | 2005-07-04 05:15:01 | Re: out of memory problem in CVS |