Re: Spinlocks, yet again: analysis and proposed patches

Stephen Frost <sfrost@snowman.net>

From: Stephen Frost <sfrost@snowman.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgreSQL.org
Date: 2005-09-12T02:39:46Z
Lists: pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> My proposal therefore is to do #2, #3, and #4, and to modify the TAS
> assembly code at least on x86_64.  Together, these changes bring
> my test case on a 4-way Opteron from
> 
> N, runtime:	1 36s	2 61s	4 105s	8 198s

em64t, 2 proc + 2 HT, 3.4ghz, 4G, 2.6.12:

N, runtime:	1 31s	2 47s	4 86s	8 159s

> to
> 
> N, runtime:	1 35s	2 48s	4 58s	8 105s

N, runtime:	1 32s	2 53s	4 90s	8 169s

CPU utilization is definitely higher when running with the patch though.
Hope this helps, happy to do additional testing if necessary.

	Thanks,

		Stephen