Elephant-utils has some of the basic thread stuff we need - only need
to import one or two operators. If we add much more we'll add
bordeaux as a dependency. Do you want to wrap this up in a bow so we
can commit it? (Did you test by adding this to the connection
creation routine in pm-controller?)
Ian
Sent from my BlackBerry
On Feb 26, 2008, at 2:18 PM, Ian Eslick wrote:
Ah, you have alot of short-lived threads? A quick look at pm-
controller.lisp seems to indicate that pm-postmodern does not close
connections when the thread closes.
Perhaps you can add a function to do this explicitly or better,
simply scan through active threads and cull any connections for
which the opening thread has been terminated. If you do this only
when a new connection is being opened, and the thread count is
reasonable, this should be cheap. I think there are some lisp-
independent thread abstractions in elephant-utils. If not, we might
import one for (get-all-threads) and some unique identifier per
thread.
Check out pm-controller.lisp for details.
Ian
On Feb 26, 2008, at 1:38 PM, Leslie P. Polzer wrote:
Sounds like you're opening to many connections to the db. How many
threads do you have? Each thread opens it's own socket to the
server
so if you have 100 threads, you have 100 connections to the server.
Well, like I pointed out in my first mail, the threads are very few.
They make peak to five or a bunch more, but most of that won't access
the database. The main problem is that the idle workers don't get
reaped by PG...
Leslie
--
My personal blog: http://blog.viridian-project.de/
_______________________________________________
elephant-devel site list
elephant-devel@common-lisp.net
http://common-lisp.net/mailman/listinfo/elephant-devel
_______________________________________________
elephant-devel site list
elephant-devel@common-lisp.net
http://common-lisp.net/mailman/listinfo/elephant-devel
_______________________________________________
elephant-devel site list
elephant-devel@common-lisp.net
http://common-lisp.net/mailman/listinfo/elephant-devel
