Skip site navigation (1) Skip section navigation (2)

Re: [ADMIN] 7.4.2 out of memory

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Jie Liang <jie(at)stbernard(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [ADMIN] 7.4.2 out of memory
Date: 2004-04-28 19:57:21
Message-ID: Pine.LNX.4.33.0404281356130.8346-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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;




In response to

pgsql-performance by date

Next:From: Jie LiangDate: 2004-04-28 20:41:21
Subject: Re: [ADMIN] 7.4.2 out of memory
Previous:From: Jie LiangDate: 2004-04-28 18:12:17
Subject: 7.4.2 out of memory

pgsql-admin by date

Next:From: Tom LaneDate: 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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group