Re: Regress tests to improve the function coverage of schemacmds and user and tablespace files - Mailing list pgsql-hackers

From Haribabu kommi
Subject Re: Regress tests to improve the function coverage of schemacmds and user and tablespace files
Date
Msg-id 8977CB36860C5843884E0A18D8747B0372BEFF86@szxeml558-mbs.china.huawei.com
Whole thread Raw
In response to Re: Regress tests to improve the function coverage of schemacmds and user and tablespace files  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
<div class="WordSection1"><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New
Roman","serif";color:windowtext">On</span><span style="font-size:12.0pt;font-family:"Times New
Roman","serif";color:windowtext">24November 2013 03:04 David Rowley wrote:</span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif";color:windowtext"> </span><p class="MsoNormal"><span
style="color:windowtext">>I'vedone a quick benchmark on this this morning.</span><p class="MsoNormal"><span
style="color:windowtext">>Notethat I'm using windows here and I used powershell to time the regression run with the
followingcommand:</span><p class="MsoNormal"><span style="color:windowtext">> </span><p class="MsoNormal"><span
style="color:windowtext">>PSD:\Postgres\b\src\tools\msvc> Measure-Command { .\vcregress.bat check }</span><p
class="MsoNormal"><spanstyle="color:windowtext">> </span><p class="MsoNormal"><span style="color:windowtext">>I
ranthe tests 10 times each.</span><p class="MsoNormal"><span style="color:windowtext">>I ran the patched version
first,then just did git reset --hard to revert the patched changes then I ran the tests again.</span><p
class="MsoNormal"><spanstyle="color:windowtext">> </span><p class="MsoNormal"><span style="color:windowtext">>The
averageand median results over the 10 runs are as follows:</span><p class="MsoNormal"><span
style="color:windowtext">> </span><pclass="MsoNormal"><span style="color:windowtext">>            
Patched              Unpatched         Time increased by</span><p class="MsoNormal"><span
style="color:windowtext">>Average           48.23265888       47.70979854       101.10%</span><p
class="MsoNormal"><spanstyle="color:windowtext">>Median              47.8993686          47.51177815      
100.82%</span><pclass="MsoNormal"><span style="color:windowtext">> </span><p class="MsoNormal"><span
style="color:windowtext">> </span><pclass="MsoNormal"><span style="color:windowtext">>The slowdown is not too
bad.It just around 1% increase of time.</span><p class="MsoNormal"><span style="color:windowtext">> </span><p
class="MsoNormal"><spanstyle="color:windowtext">>I've attached the results in spreadsheet format.</span><p
class="MsoNormal"><spanstyle="color:windowtext"> </span><p class="MsoNormal"><span style="color:windowtext">Thanks  for
thereview and benchmark test.</span><p class="MsoNormal"><span style="color:windowtext"> </span><p
class="MsoNormal"><spanstyle="color:windowtext">Regards,</span><p class="MsoNormal"><span style="color:windowtext">Hari
babu.</span><pclass="MsoNormal"><span style="color:windowtext"> </span><p class="MsoNormal"><span
style="color:windowtext"> </span></div>

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: psql shows line number
Next
From: Amit Khandekar
Date:
Subject: Re: COPY table FROM STDIN doesn't show count tag