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

Re: Postgresql 9.1.2 - abnormal memory usage

From: Jochen Erwied <jochen(at)pgsql-bugs(dot)erwied(dot)eu>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgresql 9.1.2 - abnormal memory usage
Date: 2011-12-12 07:04:44
Message-ID: 1238340844.20111212080444@erwied.eu (view raw or flat)
Thread:
Lists: pgsql-bugs
Monday, December 12, 2011, 1:45:42 AM you wrote:

> Jochen, could you try the attached patch?

Patch is missing a variable define for 'r' in network_sup(). Fixed patch 
attached.

Memory usage for insert ~1087MB - no change
Memory usage for index creation ~415MB - fixed.
Memory usage for select ~150MB - no increase, also fixed

The patch works for me, I'll leave the discussion if it's correct way to do
it to the developers :-)


-- 
Jochen Erwied     |   home: jochen(at)erwied(dot)eu     +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work: joe(at)mbs-software(dot)de  +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile: jochen(dot)erwied(at)vodafone(dot)de       +49-173-5404164

Attachment: 0001-Release-memory-in-inet-functions.patch
Description: application/octet-stream (3.7 KB)

In response to

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2011-12-12 08:29:36
Subject: Re: Postgresql 9.1.2 - abnormal memory usage
Previous:From: Tom LaneDate: 2011-12-12 06:26:30
Subject: Re: Postgresql 9.1.2 - abnormal memory usage

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