Re: Some interesting results from tweaking spinlocks

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Brent Verner <brent(at)rcfile(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Some interesting results from tweaking spinlocks
Date: 2002-01-06 02:30:17
Message-ID: 22963.1010284217@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message guard 2002-01-06 02:32:43 postgresql 7.2b4 bug
Previous Message Bruce Momjian 2002-01-06 01:53:43 Re: Some interesting results from tweaking spinlocks