Thread

1. 7.4.2 out of memory

   Jie Liang <jie@stbernard.com> — 2004-04-28T18:12:17Z

   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.
   
   
   Thanks.
   
   
   
   Jie Liang
   
   

2. Re: [ADMIN] 7.4.2 out of memory

   scott.marlowe <scott.marlowe@ihs.com> — 2004-04-28T19:57:21Z

   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;