-> > I'd also be suspicious of any extension modules you're using.  Maybe
-> > there's a refcounting bug in the PostgreSQL module or some place like
-> > that.
->
-> This has crossed my mind, and I've been pondering a PostgreSQL switch
-> anyway.  We're using PoPy because...well, because we've been using it for a
-> while.  PoPy doesn't seem to be all that well maintained anymore, though.
-> There seems to be a delightful range of choices for PostgreSQL modules;
-> rather too many.  Anybody got a suggestion for a good one to try?

psycopg has worked well for me.  PoPy and PygreSQL both gave me trouble
(the former didn't adhere to the DB-API properly, and the latter had
issues for a while).  psycopg seems to be small and fast.

        http://initd.org/software/psycopg

--titus