Tom Lane 写道:
>Neil Conway <[EMAIL PROTECTED]> 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 usef
>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.
>
>-Neil
>
>
>
yes, I run VACUUM ANALYZE VERBOSE then run the query,
and finally got the o
Neil Conway <[EMAIL PROTECTED]> 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 behavi
laser wrote:
> SELECT url,sum(ct) as ctperkw from ctrraw group by url order by ctperkw
> desc limit 1000;
> and the query run out of memory, the log file attached.
Have you run ANALYZE recently? You might be running into the well-known
problem that hashed aggregation can consume an arbitrary amou
