1 Feb 2003 03:10
Memory leak?
Greetings. I've been switching some of my code over to PyPgSQL and it
looks like I'm running into a memory leak in PyPgSQL. I have two
different applications running on 6 different machines, all of them but
one exhibit growth in memory utilization.
I wish I had a solution, but at the moment I only have some data points:
The two applications are not very similar.
All systems are running Postgres 7.3 and 7.3.1 and PyPgSQL 2.3. All
systems are running Python 2.2.2, the 8.0 machines via Red Hat RPMs,
the 7.3 machines via the python.org RPMs.
4 systems are running Red Hat 7.3, 2 are running Red Hat 8.0. The
one machine that doesn't seem to be exhibiting the problem is an 8.0
machine. The 8.0 machines are both running the Red Hat "7.3-6" beta
RPMs for postgresql. The others are running 7.3.1 beta RPMs.
I have converted one of the applications to use psycopg and PoPy
(Ugh), and neither of these exhibit any real memory "leaking" on the
the 8.0 machine that leaks with PyPgSQL.
I haven't been able to use PyPgSQL 2.2 with PostgreSQL 7.3.
Code that exhibits the problem:
from pyPgSQL import PgSQL as db
import random
co = db.connect('::pypgsqltest')
(Continue reading)
RSS Feed