On Wed, 28 Apr 2004, Jie Liang wrote:
> After I upgraded postgres from 7.3.4 to 7.4.2, one of my program got following error:
> DRROR: out of memory
> DETAIL: Fail on request of size 92.
> any idea??
> does memory management have big difference between 7.3.4 and 7.4.2???
> this program using a chunk of share memory and a lot of temp tables.
More than likely this is a hash aggregate problem (or can they spill to
disk in 7.4.2 yet? I don't think they can, but maybe we should ask Tom.
Try setting this before running the query and see what happens:
set enable_hashagg = false;
In response to
pgsql-performance by date
|Next:||From: Jie Liang||Date: 2004-04-28 20:41:21|
|Subject: Re: [ADMIN] 7.4.2 out of memory|
|Previous:||From: Jie Liang||Date: 2004-04-28 18:12:17|
|Subject: 7.4.2 out of memory|
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2004-04-29 04:10:03|
|Subject: Re: postgresql 7.4.2 binary for Red Hat Enterprise Linux 2.1 |
|Previous:||From: Mauro Morales M.||Date: 2004-04-28 19:43:27|
|Subject: Re: postgresql 7.4.2 binary for Red Hat Enterprise Linux 2.1|