Re: out of memory problem in CVS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: laser <laser(at)toping(dot)com(dot)cn>, pgsql-general(at)postgresql(dot)org
Subject: Re: out of memory problem in CVS
Date: 2005-07-04 05:01:18
Message-ID: 26471.1120453278@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message laser 2005-07-04 05:15:01 Re: out of memory problem in CVS
Previous Message Neil Conway 2005-07-04 04:44:08 Re: out of memory problem in CVS