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

Re: [GENERAL] Memory leak

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Michael <grim(at)argh(dot)demon(dot)co(dot)uk>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Memory leak
Date: 1999-08-25 11:54:38
Message-ID: Pine.BSF.4.10.9908250854110.86612-100000@thelab.hub.org (view raw or flat)
Thread:
Lists: pgsql-general
What version of PostgreSQL?  The "backends dying problem", I thought, was
fixed already...

On Wed, 25 Aug 1999, Michael wrote:

> Hi all
> 
> I have just isolated a big problem in one of my applications and it turns out
> to be a memory leak in postgresql on a VERY basic piece of functionality
> 
> It just caused a backend to grow to 133 MB in 4 hours running, which is
> obviously not good
> 
> Simple piece of C code to demonstrate this:
> 
>  for (loopa=0;loopa < 100000;loopa++)
>      {
>        result=PQexec(dbase,"create table test_table ( "
>                      "value int,wordnum int,refnum int,word text)");
>        PQclear(result);
> 
>        result=PQexec(dbase,"drop table test_table");
>        PQclear(result);
>      }
> 
> And watch the memory risssssssse
> 
> On an aside, any idea how long till there is a fix for the vacuum analyze
> crash, as it is cripling me having that happen.
> 
> Final question... Is there a really really good reason that when a backend
> crashes, all the other backends die and close connection rather than simply
> re-initialising their connections. If it just reinitialised transparently that
> would make it a LOT easier than having to have an extra test to see if the
> backend has mysteriously crashed after EVERY query!
> 
> Thanx
> 
> 				M Simms
> 
> -- 
> #define z(x,y) for (x=0;x<y;x++){
> main(){long int i[3]={1214606444,1864390511,1919706122};int x,y;
>  z(x,3)z(y,4)putchar((i[x]>>((3-y)<<3))&(255));
> }}}
> 
> 
> ************
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org 


In response to

Responses

pgsql-general by date

Next:From: Stuart RisonDate: 1999-08-25 12:02:49
Subject: Re: [GENERAL] changing between 6.4.1 and 6.5
Previous:From: Jens FelberDate: 1999-08-25 09:26:54
Subject: changing between 6.4.1 and 6.5

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