Re: Spinlock performance improvement proposal - Mailing list pgsql-hackers

From Doug McNaught
Subject Re: Spinlock performance improvement proposal
Date
Msg-id m38zf13gn9.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to Re: Spinlock performance improvement proposal  ("D. Hageman" <dhageman@dracken.com>)
Responses Re: Spinlock performance improvement proposal
Re: Spinlock performance improvement proposal
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] CHECK problem really OK now...
Next
From: Bruce Momjian
Date:
Subject: Re: LOCAL_CREDS -> SCM_CREDS in src/backend/libpq/auth.c:535