Hi all,
We've have a supply chain management system running under the following
configuration.
Redhat 7.1
Perl v5.6.0
Postgres 7.3.2
Perl/DBI 1.35
DBD-Pg 1.22
Please note that Postgres 7.3.2, DBI 1.35 and DBD-Pg 1.22 have been
upgraded recently.
I wrote a small script to check for any memory leak. This is what i've
found. Initially, the memory occupied was about 5 MB and then, it started
to grow at the range of 5-10k for every 1-2 minutes. After running the
script for about 40 minutes in a while loop, the memory occupied was 7.4
MB.
Here's the code snippet :
while (1) { print "sql executed and returned :", $Dbh->prepare("select user_id from
users limit 1")->execute, "\n";
}
Pls. note that there were no "lost references" in my script and it's a
very simple one. What could be the problem ?
Please advice me.
TIA.
Regards,
Guru Prasad.
Systems Engineer
bk Systems (P) Ltd.