[elephant-devel] Next issue, this time with Postmodern backend

[Ian Eslick]

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 at common-lisp.net
>> http://common-lisp.net/mailman/listinfo/elephant-devel
>
> _______________________________________________
> elephant-devel site list
> elephant-devel at common-lisp.net
> http://common-lisp.net/mailman/listinfo/elephant-devel