Re: Spinlocks and CPU Architectures

From: Emil Briggs <emil(at)baymountain(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: Spinlocks and CPU Architectures
Date: 2005-10-11 13:00:10
Message-ID: 200510110900.10895.emil@baymountain.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> Do other people reach the same conclusions?
>
> Can we make a list of those architectures for which 8.1 is known to
> perform reasonably well, with reasonable SMP scalability? I suggest that
> we record this list somewhere in the release notes, but with a comment
> to say we run on other architectures, but they have not been SMP tested
> as of date of announcement. That is important, since the release notes
> make specific claim about scalability features.
>

I posted a message last week about some tests with Tom's recent spinlock
patches on a quad opteron server running Suse 9.2. I found that the patches
helped a great deal when the concurrency level was less than or equal to the
number of processors. When it was greater than that they didn't help nearly
as much and in fact at high concurrency levels the application would run
about as fast running on a single processor as on a quad. It was better than
without the patches but that's not what I could call good scalability on this
architecture.

Emil

P.S. I did put it into production last week since the gain when the
concurrency level was <= 4 was so pronounced and it appears to be working
well.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-10-11 13:03:34 Re: PG 8.1beta3 out soon
Previous Message Simon Riggs 2005-10-11 12:53:20 Re: relational class vs partitioned table (was