Re: Using Threads?
От | Myron Scott |
---|---|
Тема | Re: Using Threads? |
Дата | |
Msg-id | 3A5205CA.8040500@sacadia.com обсуждение исходный текст |
Ответ на | Re: Using Threads? (Myron Scott <mscott@sacadia.com>) |
Ответы |
Re: Using Threads?
|
Список | 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 по дате отправления: