Re: Spinlock performance improvement proposal

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Spinlock performance improvement proposal
Дата
Msg-id m38zf13gn9.fsf@belphigor.mcnaught.org
обсуждение исходный текст
Ответ на Re: Spinlock performance improvement proposal  ("D. Hageman" <dhageman@dracken.com>)
Ответы Re: Spinlock performance improvement proposal
Re: Spinlock performance improvement proposal
Список pgsql-hackers
"D. Hageman" <dhageman@dracken.com> writes:

> The plan for the new spinlocks does look like it has some potential.  My 
> only comment in regards to permformance when we start looking at SMP 
> machines is ... it is my belief that getting a true threaded backend may 
> be the only way to get the full potential out of SMP machines.

Depends on what you mean.  For scaling well with many connections and
simultaneous queries, there's no reason IMHO that the current
process-per-backend model won't do, assuming the locking issues are
addressed. 

If you're talking about making a single query use multiple CPUs, then
yes, we're probably talking about a fundamental rewrite to use threads 
or some other mechanism.

-Doug
-- 
In a world of steel-eyed death, and men who are fighting to be warm,
Come in, she said, I'll give you shelter from the storm.    -Dylan


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] CHECK problem really OK now...
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: LOCAL_CREDS -> SCM_CREDS in src/backend/libpq/auth.c:535