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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
