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