Re: Some interesting results from tweaking spinlocks - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Some interesting results from tweaking spinlocks
Date
Msg-id 22963.1010284217@sss.pgh.pa.us
Whole thread Raw
In response to Re: Some interesting results from tweaking spinlocks  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> btw, what are y'all using to generate these nifty graphs?

> gnuplot.

Tatsuo previously posted a script to extract a gnuplot-ready data file
from a transcript of a set of pgbench runs.  I've been using that, plus
gnuplot scripts like the following (slightly tweaked from Tatsuo's
example):


set xlabel "concurrent users"
set ylabel "TPS"
set yrange [150:330]
set logscale x
set key width 5
set key right 

plot \
'bench.try2-noassert.data' title 'select spins 100' with linespoint lw 4 pt 1 ps 4, \
'bench.try2-na-s1000.data' title 'select spins 1000' with linespoint lw 4 pt 2 ps 4, \
'bench.try2-na-s10000-2.data' title 'select spins 10000' with linespoint lw 4 pt 3 ps 4, \
'bench.yield-s100-2.data' title 'yield spins 100' with linespoint lw 4 pt 4 ps 4, \
'bench.yield-s1000-2.data' title 'yield spins 1000' with linespoint lw 4 pt 5 ps 4


        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Some interesting results from tweaking spinlocks
Next
From: Tom Lane
Date:
Subject: Re: Some interesting results from tweaking spinlocks