Sccot,

Thank you very much, I think taht you are right about this.
I tested a single query, there is no problem. I'll do a full test with my program.

Jie Liang

-----Original Message-----
From: scott.marlowe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 28, 2004 12:57 PM
To: Jie Liang
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] 7.4.2 out of memory


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;




---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to