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