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.
In response to
pgsql-hackers by date
|Next:||From: Peter Eisentraut||Date: 2001-01-02 17:14:01|
|Subject: NetBSD libedit (Re: GNU readline and BSD license)|
|Previous:||From: Alfred Perlstein||Date: 2001-01-02 15:52:34|
|Subject: Re: Using Threads?|