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));
}}}