Thread

1. 7.0.3 postmaster memory leak with aborted transactions

   Richard Ellis <rellis@erols.com> — 2001-03-22T03:56:16Z

   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.
   
   

2. Re: 7.0.3 postmaster memory leak with aborted transactions

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-03-23T21:31:03Z

   Richard Ellis <rellis@erols.com> writes:
   > 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.
   
   Seems to be fixed in 7.1.
   
   			regards, tom lane