Re: Odd out of memory problem. - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Odd out of memory problem.
Date
Msg-id 4F70A21D.4070407@enterprisedb.com
Whole thread Raw
In response to Re: Odd out of memory problem.  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Odd out of memory problem.  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On 26.03.2012 19:59, Heikki Linnakangas wrote:
> On 26.03.2012 19:51, Greg Stark wrote:
>> On Mon, Mar 26, 2012 at 5:41 PM, Andrew Dunstan<andrew@dunslane.net>
>> wrote:
>>> Combo CIDs: 755490840 total in 100 blocks; 5161072 free (381
>>> chunks); 750329768 used
>>
>> I think you'll have to catch Heikki's attention to get a good answer
>> to this.
>>
>> Is it possible this job is inserting and then updating (or deleteing)
>> the row it just inserted and doing a large number of such
>> insert/update operations all within the same transaction? Or perhaps
>> it's updating the same row over and over again?
>
> .. and all that in different subtransactions.

sorry, scratch that, they don't need to be in different subtransactions.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Odd out of memory problem.
Next
From: Tom Lane
Date:
Subject: Re: Odd out of memory problem.