Re: Using Threads? - Mailing list pgsql-hackers

From Myron Scott
Subject Re: Using Threads?
Date
Msg-id 3A5205CA.8040500@sacadia.com
Whole thread Raw
In response to Re: Using Threads?  (Myron Scott <mscott@sacadia.com>)
Responses Re: Using Threads?  (Alfred Perlstein <bright@wintelcom.net>)
List pgsql-hackers

Alfred Perlstein wrote:


> 
> It's possible what you're seeing is the entire process
> wait for a disk IO to complete.
> 
> I'm wondering, how many lwps does your system use?  Are all
> the threads bound to a single lwp or do you let the threads
> manager handle this all for you?
> 

Yeah, I looked at this.  I have one thread per process that
does all flushing of buffer pages at transaction commit.
The client threads register buffer writes with this thread and
wait for this thread to complete writes
at transaction end.  Unfortuately, selects also wait which really
isn't nessessary.  I hoped this would speed
simultaneous connections.  I created this as both
a bound thread with its own lwp and a threads manager
managed thread.  I eventually settled on a threads manager
managed thread, thinking that I wanted to set the priority
of this thread low and commit as many transactions as
possible simulateously.  Maybe, I should rethink this.

As for client threads, that is managed by TAO and I
haven't really played with that configuration.

Myron Scott
mkscott@sacadia.com



pgsql-hackers by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: Using Threads?
Next
From: Peter Eisentraut
Date:
Subject: NetBSD libedit (Re: GNU readline and BSD license)