On Tue, Oct 12, 2004 at 08:03:24PM +0200, Ksenia Marasanova wrote:
> I have a custom publisher class for persistent database connection,
> based on this wiki page: http://www.quixote.ca/qx/ReusingConnections. I
> use it with PostgreSQL, psycopg and SCGI server. But there must be
> something wrong with my code, because after a while the process list is
> full of postgres connections, some of them "idle", some "idle in

Ah.  There may be other issues as well, but one thing I'd question is
using this explicit connection caching with psycopg, which does already
manage a cache of open connections internally.

--
Threaten not the comic with your lawyers' bluster,
all toothless to suppress parody and satire;
for you will not amuse him, but you may inspire him.
  (me, inspired by http://www.netfunny.com/rhf/jokes/01/Apr/mcrhf.html)