Re: Spinlocks, yet again: a new test case

On Sun, 11 Sep 2005, Tom Lane wrote:

> The files for the updated test case are attached if anyone else wants
> to try it. They are:
>
> test_setup.sql Run this to create the test tables
>
> test_run.sql A version of the test query that will run
> pretty nearly forever (until you kill it)
>
> test_run_small.sql A one-minute-or-so test query
>
> startn.sh A shell script to run N copies of
> test_run_small.sql in parallel.
>
> You need this one-time setup:
>
> createdb test
> psql -f test_setup.sql test
>
> To perform testing, do "time ./startn.sh N" for N=1,2,... up to however

With HEAD on a 4-way Xeon, I'm seeing:

1: 56 2: 120 4: 230

Removing the the non-locking test and branch, which you suggested
down-thread:

1: 55: 2: 111: 4: 207

--

Gavin