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

7.0.3 postmaster memory leak with aborted transactions

From: Richard Ellis <rellis(at)erols(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: 7.0.3 postmaster memory leak with aborted transactions
Date: 2001-03-22 03:56:16
Message-ID: 3AB977E0.A97082E@erols.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Test case:

create table test (data text unique);

Outside of psql, run this command (This is for bash):

while true ; do echo "begin work; insert into test (data) values ('This
is a test string.'); commit work;" ; done | psql

Watch the resident set size of the postmaster that the psql is connected
to as the while loop pumps data into psql.  As transactions are aborted,
the RSS of the postmaster continues to grow.  Looks like postmaster is
leaking memory somewhere.

Postgresql 7.0.3, compiled for Linux/glibc2 with gcc 2.95.2.

-- 
Microsoft is not the answer.            Boycott Microsoft Home page
Microsoft is the question.              http://www0.vcnet.com/bms
No is the answer.

Microsoft: Bringing you ten-year old technology, tomorrow, maybe.

Responses

pgsql-bugs by date

Next:From: Giles LeanDate: 2001-03-22 07:26:49
Subject: 7.1beta6 on NetBSD-1.5/i386 fails geometry test in 'make check'
Previous:From: WebmasterDate: 2001-03-22 01:09:06
Subject: Help

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