Re: [ADMIN] 7.4.2 out of memory - Mailing list pgsql-performance

From scott.marlowe
Subject Re: [ADMIN] 7.4.2 out of memory
Date
Msg-id Pine.LNX.4.33.0404281356130.8346-100000@css120.ihs.com
Whole thread Raw
List pgsql-performance
On Wed, 28 Apr 2004, Jie Liang wrote:

> All,
> 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;




pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: index usage
Next
From: Robert Creager
Date:
Subject: Re: Wierd context-switching issue on Xeon