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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Stuart Rison | 1999-08-25 12:02:49 | Re: [GENERAL] changing between 6.4.1 and 6.5 |
Previous Message | Jens Felber | 1999-08-25 09:26:54 | changing between 6.4.1 and 6.5 |